Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Exporting Expressions as a tab file or excel file using macro

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

3 Replies
Highlighted
Creator III
Creator III

Hi,

Hope this thread will be helpful.

Macro to export Script

Highlighted
Contributor III
Contributor III

Hi Bindu,

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

Highlighted
MVP & Luminary
MVP & Luminary

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