You are here
By now you know about the wonderful things that QlikView can do for you. Learning about the easiest or cleverest ways of saving time (and sometimes money) can take your QlikView experience to new levels. These are a few handy things to remember or apply to make this happen:
I use the following 2 generic scripts often in my development live Cycle.
Store and Drop all the Qlikview tables in your Model. This can be applied in the RAW or Functional Data Layer.
let noTabs = NoOfTables();
set name = '';
Q-Eye is a great tool for viewing and editing QVDs, but Q-Eye can also be used to view resident tables during a reload.
1. Download and install Q-Eye.
2. Add the following sub to the beginning of your QlikView script. If you did not install Q-Eye in the default path or you are using the portable version, you will need to change the values for the path variables.
sub EyeTheTable (xTableName)
let xProgramFilesPath = GetRegistryString('HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion', 'ProgramFilesDir');
Customisations and extensions are powerful and cool and sometimes there is no other way to achieve your objectives, but did you know you can make QlikView Applications look and navigate like Rich User Interfaces by doing some of the following:
1. Less borders – use less borders and when you do, use thinner lines drop the rounded corners;
2. Softer (pastel) colours – these are easier on the eye and more appealing to users;
3. Transparent objects - Especially graphs;
5. Use these same actions to set variables that you will use to control colours;
6. Use text boxes to navigate by:
a. Adding your actions (point 5) to these text boxes;