Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Managing Variables

cancel
Showing results for 
Search instead for 
Did you mean: 
nick_scott
Contributor III
Contributor III

Managing Variables

Attachments

Managing variables in an external spreadsheet (excel) can solve a number of problems, especially as it is not easy to import variables into a Qlikview (Qvw) document.

It is difficult to set a variable containing a "macro expansion" e.g. $(=today()) without the macro expansion being evaluated as the variable is set. If the variable is stored in an Excel file it can be "imported" with some simple script into the Qlikview document as a variable.

You can create your own Library of Variables which you can import into a new Qlikview document.

Explore & Enjoy,

Nick Scott.

Comments
vikasmahajan

Very Good !!

0 Likes
Saravanan_Desingh

Excellent one, Nick. I am having a similar requirement now

0 Likes
Version history
Last update:
‎2013-10-02 05:51 AM
Updated by: