topic Exporting Expressions as a tab file or excel file using macro in QlikView

Exporting Expressions as a tab file or excel file using macro

rajpreeths — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Is there any macro available with you to export all the expressions into a single file like we export the variables into excel file???

Currently I am doing this export manually as below

Setting --> Expression Overview-->Export-> Save File

But I have to do the same thing for 400 reports. So it would be helpful if you guys share me the macro available for doing achieving this export.

Thank you in advance!

Rajpreeth S

Re: Exporting Expressions as a tab file or excel file using macro

bindu_apte — Tue, 04 Oct 2016 08:37:20 GMT

Hi,

Hope this thread will be helpful.

Macro to export Script

Re: Exporting Expressions as a tab file or excel file using macro

rajpreeths — Tue, 04 Oct 2016 10:05:31 GMT

Hi Bindu,

I would like to have EXPRESSIONS export into a excel or tab or csv file format not script export.

Re: Exporting Expressions as a tab file or excel file using macro

marcus_sommer — Tue, 04 Oct 2016 10:18:01 GMT

I don't think that the expression overview is available/acessable per macro and to try to loop through all sheets/objects and their expression-properties would be require enormous efforts. Therefore I think the easiest way would be to export the layout-file and reading it again into qlikview (and than maybe storing or exporting them):

ActiveDocument.ExportLayoutFile "c:\AppLayout.xml"

- Marcus