Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lavina24mehra
Contributor
Contributor

How to separate Filter Pane with 2 different pivot tables

Hi,

 

I am new to Qlik Sense and have initial build queries. I have to build a report in which 2 pivot tables should be there with one filter pane affecting the first pivot table and second filter pane impacting the second pivot table.

Both the filter panes have the same column but different selection criteria for 2 different pivot tables.

 

Thanks.

1 Reply
ChiragPradhan
Creator II
Creator II

Hi,

You can achieve this by using Alternate States. You can create two alternate states, one for each pivot table/filter pane, in Master Items.

Alternate_states.PNG

 

 

 

 

 

Alternate States was introduced from November 2018 version, so you need to have Qlik Sense November 2018 or higher.

Find attached a sample app.

Regards,

Chirag