Show 0 value in chart.

narender123 — Thu, 11 Jul 2013 13:07:33 GMT

Hi All,

I have created weekly revenue collection report.

Its working well .When i select a day from day filter then its will show the that day week collection as shown below.But but it is not showing 06/09/2013 date of that week due to 0 amount at 06/09/2013 date.how i can show 0 amount too with 06/09/2013??????????

expression.

=if(GetSelectedCount(Day)=0 ,sum({<Year={$(=max(Year))},Month={$(=MaxString(Month))},Week={$(=Week(Today()-1))},Day=,Month=>}AMOUNT),sum({<Year={$(=max(Year))},Month={$(=MaxString(Month))},Week={$(=vWeek)},Day=,Month=>}AMOUNT))

Please Advice me.

Thanks.

Re: Show 0 value in chart.

swuehl — Thu, 11 Jul 2013 13:44:15 GMT

Please check that option 'suppress zero values' in presentation tab of chart properties is unchecked.

I assume that your date is taken from a calendar table, so there is a record for that date, just the sum(... AMOUNT) is evaluated to zero?

topic Re: Show 0 value in chart. in QlikView

Show 0 value in chart.

Re: Show 0 value in chart.