Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
CNH_1978
Contributor II
Contributor II

Defining set analysis in a variable and using the variable within the expression

Hi, 

I am defining some set analysis in a variable like below..

vSetAnalysis

MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}

I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..

Sum({<'$(vSetAnalysis)'>}Sales)

Can anyone help to get this to work please?

Labels (1)
2 Replies
CNH_1978
Contributor II
Contributor II
Author

Does anyone have any ideas?

NitinK7
Specialist
Specialist

Hi

set variable like

vSet=monthyear

vr.JPG

 

then write below set analysis expression in textbox

=Sum({<Monthyear={"=$(vSet)"}>}sales)

or 

You can use below expression

=sum({<vSet>}sales)