Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
BR
BMK
Can you try this
='(' & Concat('W' & ValueLoop(Week(Today())-3, Week(Today())), '|') & ')'
May be
='>' &Max(Week-4) & '<=' & Max(Week)
Can you try this
='(' & Concat('W' & ValueLoop(Week(Today())-3, Week(Today())), '|') & ')'
Hi,
Thanks. Somehow, it didn't work for me. It might be because of the presence of string (W) in week.
Thanks Sunny.
It worked.
🙂 🙂