How can I preserve the filter selections in a sheet of the application ?

[userpd_2021]

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.

Qlik Sense Business  

[stevedark]

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

[durgesh22]

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 

[userpd_2021]

Thanks , I will try this one