Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

alexprost
New Contributor II

Zero-sum in simple table graphics

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

1 Solution

Accepted Solutions
kumarnatarajan
Valued Contributor

Re: Zero-sum in simple table graphics

Hi,

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

Find the attached file

4 Replies
sushil353
Honored Contributor II

Re: Zero-sum in simple table graphics

hi,

goto presentation tab and uncheck supress zero value option.

HTH

Sushil

kumarnatarajan
Valued Contributor

Re: Zero-sum in simple table graphics

Hi,

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

Find the attached file

Not applicable

Re: Zero-sum in simple table graphics

dimension check supress null value.

and expression write

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

alexprost
New Contributor II

Re: Zero-sum in simple table graphics

Thanks a lot for your quick answers !!!

Community Browser