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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multiple varible inside set analysis


Can we pass multiple variable inside set analysis? i am passing 4 variables, but does not work

21 Replies
Anonymous
Not applicable
Author

ya with hardcode it works, but i want dynamic values

qlikmsg4u
Specialist
Specialist

=avg({$<Environment={'$(vEnvironment)'},Component={'$(vComponent)'},Year={'$(vPrevmnth2)'},Month={'$(vPrevmnth1)'}>} usage)


vPrevmnth1=Num(month(AddMonths(Today(),-1)))

vPrevmnth2=year(Today())

try this, if it is not working post your app