Zero-sum in simple table graphics

[alexprost]

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]

hi,

goto presentation tab and uncheck supress zero value option.

HTH

Sushil

[kumarnatarajan · Accepted solution]

Hi,

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

Find the attached file

[#4]

dimension check supress null value.

and expression write

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

[alexprost]

Thanks a lot for your quick answers !!!