Discussion board where members can get started with Qlik Sense.
I am using 'Button For Navigation' extension from Qlik Sense Bundle.
Button Action: I want latest 4 weeks should be selected by clicking on it
For that I have used 'Select a value in a Field' action and selected Week field(my Week field has data like W1, W2, W3 etc.,)
and to select latest 4 weeks i wrote the below expression and it is not working because I have 'W' in my week representation
='>' &(Week(Today())-4) & '<=' & Week(Today())
So, my question is how to select latest 4 weeks data where week field has data in the format W1('W' & Weeknumber)
Thanks in advance
Can you try this
='(' & Concat('W' & ValueLoop(Week(Today())-3, Week(Today())), '|') & ')'
View solution in original post
='>' &Max(Week-4) & '<=' & Max(Week)
Thanks. Somehow, it didn't work for me. It might be because of the presence of string (W) in week.