topic Re: Hide negative values in bar chart in QlikView

Hide negative values in bar chart

sundarakumar — Fri, 10 Jan 2014 04:29:41 GMT

Hi all,

Can anyone please tell me how to hide only the negative values in a bar chart?

I dont want them to appear in the chart itself. Where should i give the condition?

-Sundar

Sokkorn — Fri, 10 Jan 2014 04:38:33 GMT

Hi Sundar,

You may look into your expression. Something like If(Sum([Field])<0,Null(),Sum([Field]))

Can you attached your app here?

Regards,

Sokkorn

VishalWaghole — Fri, 10 Jan 2014 04:40:12 GMT

Hi Sundarakumar,

Try this expression in ur chart,

=if(sum(Field)>0,sum(Field))

- Regards,

Vishal Waghole

sushil353 — Fri, 10 Jan 2014 04:44:19 GMT

Hi,

You can remove negative values using dimention limit as well.

In Dimension limits> check option "Show only values that are" > Greater Than , 0 , exact amout

Uncheck "Show Others" from options.

HTH

Sushil