Button Action to select 4 weeks

[mohan2391]

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

[Anil_Babu_Samineni]

May be

='>' &Max(Week-4) & '<=' & Max(Week)

[sunny_talwar · Accepted solution]

Can you try this

='(' & Concat('W' & ValueLoop(Week(Today())-3, Week(Today())), '|') & ')'

[mohan2391]

Hi,

Thanks. Somehow, it didn't work for me. It might be because of the presence of string (W) in week.

[mohan2391]

Thanks Sunny.

It worked.

🙂 🙂