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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to exclude a value in a dimension

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

1 Solution

Accepted Solutions
sunny_talwar

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}>}

View solution in original post

4 Replies
sunny_talwar

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}>}

Not applicable
Author

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?