topic Re: Zero-sum in simple table graphics in QlikView

Zero-sum in simple table graphics

alexprost — Tue, 21 May 2013 09:52:05 GMT

Hi,

How can I display a row in a simple table graphic when expression equals zero ?

I build a simple qlikview sample to illustrate:

- An inline table loads data with name and amount

- A simple table graphic displays name and sum(amount)

When sum equals zero, the row is deleted.

Can anyone help me ?

Thanks

Alexandre

sushil353 — Tue, 21 May 2013 09:58:08 GMT

hi,

goto presentation tab and uncheck supress zero value option.

HTH

Sushil

kumarnatarajan — Tue, 21 May 2013 09:58:14 GMT

Hi,

Go to Properties-> presentation -> then uncheck suppress zero-value.

Find the attached file

Tue, 21 May 2013 09:58:22 GMT

dimension check supress null value.

and expression write

if(sum(amount)=0,'',sum(amount))

alexprost — Tue, 21 May 2013 10:06:19 GMT

Thanks a lot for your quick answers !!!