Author: Andre Van Der Merwe.

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.

Step 1. 

Download and install Q-Eye.

Step 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 


Step 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)');

Step 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');

Step 5.

Reload the QlikView document.

Step 6.

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

Step 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]

Step 8.

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

Step 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.

Step 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.

Step 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]

Views: 683

© 2021   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service