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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 )