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

Exclude value in Dimension

I want to exclude "Alfa" team in my pivot table. I need to see only Beta and Charlie values. What should i write in the "Enable Conditional" exactly?

 

Here is the "Team" list:

 

Alfa

Beta

Charlie

 

and here is the my Dimensions Tab:

Capture.PNGHello everyone.

 

 
 
 

 

2 Replies
Victor_Alumanah
Creator
Creator

Hi there,

If you do not have many expressions, one option would be to use one of the examples below in the expression area.

Count({$<Team-={'Alfa'}>}AMOUNT)

Sum({$<Team-={'Alfa'}>}AMOUNT)

While we teach we learn
asknyldz
Contributor III
Contributor III
Author

Thank you Tilnu,

 

The problem is the there are too much expression.

Is it possible to solve in the Dimension tab?