Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
l26b
Contributor III
Contributor III

How to apply dynamic week filters across multiple sheets in Qlik Cloud app

Hi all,

I have a Qlik Cloud app that includes several years of data, and I want to apply week-based filters dynamically across different sheets:

  • Some sheets should always show current week data

  • Others should default to previous week data

At the same time, I want to make sure:

  • The filter uses current week and if the formula is set to say max(week) it will choose from the max weeks from previous years and the same for previous week

  • If a user changes the week filter on a sheet that defaults to "current week", that selection should be retained across sheets and not automatically reset when navigating

What would be the best approach to apply this logic?

Thanks in advance!

Labels (3)
3 Replies
Anil_Babu_Samineni

This could be combination of below

1) Activate Sheet

2) Activate Variable that shows current vs previous week

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
l26b
Contributor III
Contributor III
Author

hi, this is not the result I want actually since this is not keeping the other filters between pages

Anil_Babu_Samineni

Could you please explain how you want to develop with use cases? 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful