Previously, business intelligence and big data were reserved for big companies with an even bigger budget. Luckily now, with new technology and software, business intelligence is available to small businesses as well on an affordable level.
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');