Restrict one of the filters on one sheet

[adias102]

Hi,

I have 2 identical sheets that display several KPIs and a multi KPI. There are also 3 filters on each sheet: district, year and area.

I want to use one sheet to display data according to all filters, that is KPIs for a chosen district,year and area.

For the second sheet I want to display the same KPIs but for the entire organization and use only 2 of the filters: year and area. I don't want the district filter to have an impact on this sheet, but the other filters should affect the display on both sheets.

I tried to use alternate states but it doesn't work since I have 2 other filters.

Is it possible with Qlik Sense?

[JordyWegman · Accepted solution]

Hi Adias,

What you can try is to create two formulas:

1. The first is the normal formula
2. The second you add set analysis <${ district = }>

This way, the selection of district has no effect on your KPIs on the second sheet if you added the set analysis. 

Jordy

Climber

[adias102]

Thank you so much 🙂