Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
This could be combination of below
1) Activate Sheet
2) Activate Variable that shows current vs previous week
hi, this is not the result I want actually since this is not keeping the other filters between pages
Could you please explain how you want to develop with use cases?