I have a requirement in Qlik sense that i have 3 sheets in a app and in the third sheet I need to set max month as default selections and sheet1and sheet2 should not be affected based on this selections applied on the 3rd sheet.
Any suggestions would be highly appreciated on this regard.
Set the filter pane to filter by Month: Select the month field you want to filter.
Use an expression in the filter pane: Use the expression =Max(MonthField) (replace MonthField with the name of your month field) to select the maximum month.
Create a bookmark: Save the current state of the filter pane (which should now be filtering for the maximum month) as a bookmark. Set bookmark as default: Right-click on the bookmark and choose "Set as default bookmark".
Create an action to clear all selections under the sheet properties in other sheets.(While navigating to other sheets, action will clear all selections which you have made earlier)
