Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
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 )
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 )
Thanks @tresesco !! Work perfect