Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Go to Properties-> presentation -> then uncheck suppress zero-value.
Find the attached file
hi,
goto presentation tab and uncheck supress zero value option.
HTH
Sushil
Hi,
Go to Properties-> presentation -> then uncheck suppress zero-value.
Find the attached file
dimension check supress null value.
and expression write
if(sum(amount)=0,'',sum(amount))
Thanks a lot for your quick answers !!!