How to apply one filter criteria for entire sheet

[deepak_km9886]

Hi, Say i have a dimension with name A and B.

I don't want end user to see this filter pane with name,

but all the charts and kpi within sheet1 should be for the value A.

and all the charts and kpi withiin sheet2 should be for the value B.

How to write set expression or if statement to achieve this.?

[thi_pham]

Instead of creating 2 sheets, you can consider to create 2 bookmarks respectively to selection of A and B.

[ogster1974]

This next solution would involve a filter but would be more dynamic

Big Data and Qlik Sense - On Demand App Generation

[deepak_km9886]

Where will be the properties will be available?

[deepak_km9886]

How to show the bookmark with the value A and B selected as part of app which has 20 sheets?

[hemeshreddy]

By right clicking on the sheet i.e empty space(which doesn't have any object)

[hemeshreddy]

in qlikview