Exporting Variables to Excel using Extensions

Arthur_Fong · Sep 21, 2022 1:07:35 PM

Hi all,

I have been struggling on how to export all variables into Excel for documentation purposes(eg: Technical Specifications).

There are a few options to do that, which involves creating macros in QV.

Here, I would like to share an extension created by myself for exporting variables to Excel.

PS: I am not a pro in Javascript, hence many of js script is modified from other source codes.

Thanks to Dmitry Gudkov for the splendid walk through on how to create extensions,

Intro about extension can be found here:

Please go through this post if you are new towards extensions.

After pasting the attached folder into:

C:\Users\<UserName>\AppData\Local\QlikTech\QlikView\Extensions\Objects\<Attached Folder>,

click on Webview(top right panel) in QlikView, right click on the empty space and select "+ New Sheet Object".

Select "Extension Objects" under the dropdown list and you should see "Exporting Variables".

Drag the left 4-headed arrows into the empty page of QV.

You should see a list of system variables and front-end created variables as below:

Click on Export button(Top left) and select the filepath to save.

Boom! QV Variables are exported to Excel.

Credits to Dmitry Gudkov and the exporting function source code can be found here:

Thanks and regards,

Arthur Fong