topic Store expression into excel sheet and re-use expressions in many charts using variables in QlikView

Store expression into excel sheet and re-use expressions in many charts using variables

vikasmahajan — Wed, 27 May 2015 09:50:01 GMT

Dear all,

I have excel sheet containing expressions and there name this formula I want to store into variable and after reload want to use in expression. One formula is used many times so I want to re-use the same again and agian.

NAME	VALUE
GSAL	SUM({$<FiscalYear={$(=max(FiscalYear))}>} [Gross Sales Amount])/10000000

Regards

Vikas

Re: Store expression into excel sheet and re-use expressions in many charts using variables

Siva_Sankar — Wed, 27 May 2015 09:59:40 GMT

Vikas, Try checking the below qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

Re: Store expression into excel sheet and re-use expressions in many charts using variables

petter — Wed, 27 May 2015 10:00:11 GMT

Yes there are many examples on the Community showing how to do it ... try searching. Basically you just read them in as a regular table

And then you have a FOR NEXT loop through all rows of the table where you do a Peek and $-expansion to create variables.

You could actually just refer the table in itself and the row explicitly having the table as a Data Island and then do a lookup in your expressions directly without storing every expression in a separate variable.

Re: Store expression into excel sheet and re-use expressions in many charts using variables

Siva_Sankar — Wed, 27 May 2015 10:00:37 GMT

PFA

Re: Store expression into excel sheet and re-use expressions in many charts using variables

swuehl — Wed, 27 May 2015 10:03:07 GMT

I think it's even explained in the HELP or manual. But here you go with the forum:

Variables (with SA) declaration from excel file