You are here

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.

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]

QlikView south africa

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]

QlikView south africa

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

QlikView south africa

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.

QlikView south africa

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.

QlikView south africa

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]