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.
TheResidentTable:
load * inline [
Customer Code,Customer Name
35616444,Zoombeat
30304603,Centidel
35438170,Flashpoint
30394002,Oba
];
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]