If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am new to this and I am having a challenge how to get data ONLY between 2 values.
I have 2 variables,
$(v_Curr_WeekNum) = 36
$(v_CurrWeek-12) = 22
I have a Line Chart,
I want to limit the data that shows between $(v_CurrWeek-12) and $(v_Curr_WeekNum)
something like this,
=week($(v_CurrWeek-12)> $(v_Curr_WeekNum) )
So far I got only either current value or 12 weeks low value
How do I get the expression to show data points like 22,23,24,25,26,27,...... 36
Any help would be really appreciated. Thanks
You can use expression in the dimension instead of the field directly. Try expression like:
=If(Week>=$(v_CurrWeek-12) and Week <=$(v_Curr_WeekNum), Week )
View solution in original post
Thanks @tresesco !! Work perfect