Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

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

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.

 

NAMEVALUE
GSALSUM({$<FiscalYear={$(=max(FiscalYear))}>} [Gross Sales Amount])/10000000

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
4 Replies
Siva_Sankar
Master II
Master II

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

petter
Partner - Champion III
Partner - Champion III

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.

Siva_Sankar
Master II
Master II

PFA

swuehl
MVP
MVP

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