Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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}>}
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}>}
Thanks sunny for quick reply
I have written the first expression..
but i didnt check that checkbox thats y i couldnt get the result..
Oh okay, it is very important to suppress null once you use calculated dimension.
P.S. did you get my email?
Hi, can you answer my question also? https://community.qlik.com/t5/QlikView-App-Dev/Filtering-dimension-based-on-object-selection-button/...