Exclude 0 and -1 from a chart

[#1]

Hello everyone,

I have a graph with several expressions made with sets analysis. Their aims is to display a percent of type of lines compare to the rest of the other lines.

My problem is that I obtain values "-1" and "0" in my dimension. These values doesn't exists at origin in my table.

Do you know how I can hide these -1 and 0 ?

Thank you !

[alexandros17 · Accepted solution]

if your expression is something like MYEXPR then

write:

if(MYEXPR  <= 0, null(), MYEXPR )

let me know

[sasikanth]

if(dimension_name<>'-1' and dimensionn_name<>'0' , dimension_name,0)

[SunilChauhan]

if(column(1)< 0, null(), column(1))  

here column(1)----> denotes first expression you can use column(N)-->n=1,2,3.......

and  go to chart -> properties-> presentation-> supress zero value

hope this helps

[#5]

Can you please share your qvw to better explain what you want to achieve?

[SunilChauhan]

you can also  do below

go to excess and in static min write 1

hope this helps

[#7]

Thanks for your responses !