topic Re: nulls and zeros in the same column? in QlikView

nulls and zeros in the same column?

Wed, 28 Jan 2015 14:52:42 GMT

I have a Straight Table chart, where I am trying to get zero values display as '0' and rows where there is no value either blank or '-'.

My formula is as follows:

=IF([launched in last 6 months]='Yes',0,SUM({1<WeeksAgo={'1'}>}[Total Volume (M)]))

But even if there is no data for the row, it's still displaying as '0'.

How do I get the '-' to appear, or for the cell to be blank when there's no data?

Gysbert_Wassenaar — Wed, 28 Jan 2015 15:00:07 GMT

Change the number format for the expression on the Number tab to #.##0;-#.##0;-

robert_mika — Wed, 28 Jan 2015 15:05:28 GMT

Maybe nested IF will help

Something like:

=IF([launched in last 6 months]='','-',IF([launched in last 6 months]='Yes',0,SUM({1<WeeksAgo={'1'}>}[Total Volume (M)])))

Wed, 28 Jan 2015 15:55:37 GMT

Top man Gysbert!!