Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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.
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