topic Re: Expression help !!! in QlikView

Expression help !!!

amit_saini — Wed, 30 Jul 2014 04:53:10 GMT

Hi Folks,

Below I'm calculation expression as Act Scrap% of Revenue New=sum([Act. Scrap $])/sum([Act Revenue]) , My requirement Is it possible to show empty space if no value can be calculated? Instead of 0.0% it should show no values (Blank).

Thanks,

Re: Expression help !!!

Wed, 30 Jul 2014 04:59:26 GMT

Hi Amit,

You can have if condition in your expression something like below

=If(sum([Act. Scrap $])/sum([Act Revenue])=0.0,'',sum([Act. Scrap $])/sum([Act Revenue]))

There must be other approach to tackle this, but this is what I got it quick.

Thanks

Arindam

Re: Expression help !!!

tresB — Wed, 30 Jul 2014 05:02:51 GMT

Try like:

=If( sum([Act. Scrap $])/sum([Act Revenue])<>0,

sum([Act. Scrap $])/sum([Act Revenue]),

null()

)

And then unchech 'Supress Missing' in the presentation tab.