Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

becki_kain
New Contributor III

dump variables and expressions and global number set format?

Enclosed is a simple project but as you can see, certain expressions (fields/columns) are dependent on other expressions.  Is there a way to dump all variables with their definitions and all expressions, with theirs, to a flat file of some sort?  I want to dump all of them to look for expressions which are no longer being used.

second question, if i'd like all expressions formatted as "#.#;(#.#) " (all expressions are numeric).  I know I can set each one with properties->number->format pattern but is there a way to do this for all numbers, in the load script?

1 Solution

Accepted Solutions
Highlighted
lorenzoconforti
Contributor III

Re: dump variables and expressions and global number set format?

Hi

Regarding exporting all the expressions, go to the expression overview (CTRL+ALT+E) and click on Export

Untitled.jpg

Regarding setting a default format, you can do it at a field level by going to Document Properties > Number (see below)

Untitled2.jpg

Regarding exporting variables, I don't think there is a built in way of doing it; have a look at this document:Export Variables.zip

The solution would require writing macros

4 Replies
Highlighted
lorenzoconforti
Contributor III

Re: dump variables and expressions and global number set format?

Hi

Regarding exporting all the expressions, go to the expression overview (CTRL+ALT+E) and click on Export

Untitled.jpg

Regarding setting a default format, you can do it at a field level by going to Document Properties > Number (see below)

Untitled2.jpg

Regarding exporting variables, I don't think there is a built in way of doing it; have a look at this document:Export Variables.zip

The solution would require writing macros

Re: dump variables and expressions and global number set format?

The Document Analyzer tool

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

can help you identify unused variables and fields.

You can export expressions and variable from the charts in the tool if you wish.

This application

http://www.qlikfix.com/2013/09/06/importing-and-exporting-variables/

from Barry Harmsen can also be used to bulk export/import variables from a qvw.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

becki_kain
New Contributor III

Re: dump variables and expressions and global number set format?

thanks!

becki_kain
New Contributor III

Re: dump variables and expressions and global number set format?

as far as setting the numbers to a format, I tried the settings->document preferences-> number and putting in the format of

#.#;(#.#)  but it gives me a list of the input fields, not the output expressions.  i'm not certain which input field to tie the formatting to.