topic Re: Exclude 0 and -1 from a chart in QlikView

Exclude 0 and -1 from a chart

Thu, 26 Jun 2014 10:07:01 GMT

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 !

Re: Exclude 0 and -1 from a chart

alexandros17 — Thu, 26 Jun 2014 10:08:40 GMT

if your expression is something like MYEXPR then

write:

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

let me know

Re: Exclude 0 and -1 from a chart

sasikanth — Thu, 26 Jun 2014 10:09:08 GMT

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

Re: Exclude 0 and -1 from a chart

SunilChauhan — Thu, 26 Jun 2014 10:11:12 GMT

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

Re: Exclude 0 and -1 from a chart

Thu, 26 Jun 2014 10:11:20 GMT

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

Re: Exclude 0 and -1 from a chart

SunilChauhan — Thu, 26 Jun 2014 10:16:58 GMT

you can also do below

go to excess and in static min write 1

hope this helps

Re: Exclude 0 and -1 from a chart

Thu, 26 Jun 2014 11:28:15 GMT

Thanks for your responses !