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: 
warrenpress
Contributor III
Contributor III

using variable in place of dimension in set analysis


Hi,

I currently have the following expression

sum({$<L4L_Flag_2014={'Y'}>} qty)

which i need to make dynamic using a variable called L4L_Flag

L4L_Flag is set using the follow expression

if(Year=2014,L4L_Flag_2014,L4L_Flag_2013)


How do i replace the L4L_Flag_2014 dimension in the initial expression with the variable L4L_Flag ??

I tried sum({$<$(L4L_Flag)={'Y'}>} qty) but to no avail.

Thanks in advance

10 Replies
warrenpress
Contributor III
Contributor III
Author

Thanks tresesco.

I knew it had to be something simple.