QlikView: Using Q-Eye to view resident tables.

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’);

let xQEyePath = ‘$(xProgramFilesPath)\DB Software Laboratory\Q-Eye\QEye.exe’;

store $(xTableName) into [$(QvWorkPath)\~$(xTableName).qvd] (qvd);
execute “$(xQEyePath)” “$(QvWorkPath)\~$(xTableName).qvd”;
execute cmd /c del “$(QvWorkPath)\~$(xTableName).qvd”;

let xProgramFilesPath=;
let xQEyePath=;
end sub

3.       If using the 32bit version with default install, the program files variable is as follows

let xProgramFilesPath = GetRegistryString(‘HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion’, ‘ProgramFilesDir (x86)’);

4.       Add the sub call in the script where needed, passing in the name of the resident table.

load * inline [
Customer Code,Customer Name

call EyeTheTable(‘TheResidentTable’);

5.       Reload the QlikView document.

6.       If the Security Alert dialogue pops up, click [Override Security, Execute This Statement]

7.     To disable this dialogue in the future, go to the [Settings] tab at the bottom of the QlikView Script Editor in tick [Can Execute External Programs]

8.      If the Script Security dialogue pops up, click [Give System Access]

9.       To disable this dialogue in the future, go to Tools | Edit Module… or press [Ctrl-M] to open up the Module Editor and change the security dropdowns as shown below.

10.       The Q-Eye Editor will now open up, allowing you to view the resident table’s data. When you close the Q-Eye editor, the script will continue to reload.

11.      If you have not ticked [Can Execute External Programs] in the settings tab, the Security Alert dialogue will pop up again. Click [Override Security, Execute This Statement]