Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
How can I force certain value/filters in only one sheet and the selection shouldn't change even if user try to change it to some other value explicitly.For Weekly view, make filter Week to select latest week; Similarly for Monthly view, make filter Month to select latest month.
Hi @userpd_2021
The feature you are wanting to use here is called Set Analysis, and you will find plenty written about it online.
Basically, it allows you to force a selection within the expression of your chart. So, to get the value in a chart for the previous month it would be:
sum({<Month*={"$(=date(monthstart(today()), 'MMM-YYYY')"}>}Value)
What is important is that the format of the expression in the $(= ) returns a date in the same format as the value appears in the data model - or it doesn't work.
I've a few examples of set analysis that you might like to look at:
https://www.quickintelligence.co.uk/prior-period-comparison/
https://www.quickintelligence.co.uk/qlik-set-analysis-star-equals/
Hope that helps point you in the right direction.
Steve
As per details you provided you can use Set analysis,
Sheet1 keep data for a week using set expression, and try modifying expression as per your requirement
Thanks , I will try this one