topic Re: Exclude 0 values from the Trellis Chart in QlikView

Exclude 0 values from the Trellis Chart

Anonymous — Fri, 16 May 2014 21:34:51 GMT

Hello!

Is there a way to exclude the chart with 0 values from the Trellis Chart? Right now, one of my dimensions with 20 Values is in the chart...It would be more nicer if those charts in the Trellis have values..

Tks.

Re: Exclude 0 values from the Trellis Chart

Fri, 16 May 2014 23:39:40 GMT

Cacosta,

may you attach sample?

regards

Darek

Re: Re: Exclude 0 values from the Trellis Chart

Anonymous — Sat, 17 May 2014 00:39:05 GMT

Hi! Darek,

Pls. see attached...Thank you for your time.

Rgds.

Re: Exclude 0 values from the Trellis Chart

MK_QSL — Sat, 17 May 2014 06:07:44 GMT

Change your expression as below

MONEY(IF(SUM(Value)<>0,SUM(Value)/100000))

Re: Re: Exclude 0 values from the Trellis Chart

Sat, 17 May 2014 06:20:29 GMT

Hi Manish,

this may be dangerous if you will have elements different than 0 but summing to 0.

regards

Darek

Re: Re: Exclude 0 values from the Trellis Chart

Sat, 17 May 2014 07:15:06 GMT

I'm sorry, probably not yet woken up. I need coffee

Even if the condition is safe, it seems that does not work, so I suspect cacosta wants. It seems to me that the dimensional coordinates of each subchart of trellis will be the same and if any value is to coordinate, it is in all the others, even with a value of zero, this coordinate occurs. It seems that once saw a thread on this topic ...

I will try to check more later.

regards

Darek

Re: Exclude 0 values from the Trellis Chart

SunilChauhan — Sat, 17 May 2014 07:51:47 GMT

Hi,

all the MFR dimesnion values has similar age i.e 0-8,9-15.........................

zero value can not be removed untill every age has zero value. for example if for age 0-8 if value would zero

for one dimesion then on removing zero it helps

other wise not

try reducing your denominator from 100000 to 10000 or 1000.this will helps to show more values on charts

hope this helps

Re: Exclude 0 values from the Trellis Chart

Anonymous — Tue, 20 May 2014 20:52:32 GMT

Sunil,

I just reduced my denomitor to 1000 to show some values.

Tks.