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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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?

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)