how to exclude a value in a dimension

[#1]

Hi all

How to exclude a value from a dimension in a pie chart.

I have a column as dimension , column has values like 200,300,400,500

my pie chart shows the values for each values in the dimension but i want to exclude the value 200 from my dimension in pie chart..

How to write an expression to exclude the value from the dimension

Thanks

[sunny_talwar · Accepted solution]

2 ways to do this

1) Calculated dimension

If(Dimension <> 200, Dimension)

and then check 'Suppress When Value Is Null' on the dimension tab

2) Use Set analysis in your expression

{<Dimension -= {200}>}

[#3]

Thanks sunny for quick reply

I have written the first expression..

but i didnt check that checkbox thats y i couldnt get the result..

[sunny_talwar]

Oh okay, it is very important to suppress null once you use calculated dimension.

P.S. did you get my email?

[prathmeshb27]

Hi, can you answer my question also? https://community.qlik.com/t5/QlikView-App-Dev/Filtering-dimension-based-on-object-selection-button/...