topic Exclude value in Dimension in QlikView

Exclude value in Dimension

asknyldz — Wed, 25 Nov 2020 16:16:04 GMT

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:

Hello everyone.

Re: Exclude value in Dimension

Victor_Alumanah — Thu, 19 Sep 2019 11:59:23 GMT

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)

Re: Exclude value in Dimension

asknyldz — Thu, 19 Sep 2019 12:32:55 GMT

Thank you Tilnu,

The problem is the there are too much expression.

Is it possible to solve in the Dimension tab?