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!
A opção mais simples seria utilizar ações ao navegar entre pastas, porém como você quer manter o filtro, a melhor abordagem seria realizar o SetAnalysis em cada objeto respeitando a regra aplicada