Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
guibsantos
Contributor II
Contributor II

Filter Pane selections

Hello Comunity, 

I have a pivot where I have as a dimension column a field called 'Scenario' which fields are (A20, A21, A22, B20..)

I am using at the same time a filter pane for Scenario and I would like to restrict the selections to just 2, which would give me a maximum number of 2 columns for the pivot.

How can I do this for the filter Pane?

 

Thank you a lot!

Labels (1)
1 Reply
PradeepK
Creator II
Creator II

I think what you want is calculated column dimension in pivot table. To restrict columns to only 2 dimension values.

Use simple if condition in dimension field and hide null values

if( Scenario = 'A20' or Scenario = 'A21' , Scenario )