topic Re: Null values in chart in QlikView

Null values in chart

Karl_Hart — Thu, 25 Sep 2014 10:22:48 GMT

I have a table that uses the expression

=sum({$<FiscalMonthNumeric = {"<=$(=max(FiscalMonthNumeric))"}, Month=>}Data)

and the results of this are

Apr 5%

May 6.78%

Jun 0%

Jul 4.76%

Aug 1.75%

The bar chart only shows the results that aren't 0 (i.e. Apr, May, Jul and Aug)

I have "Show All Values" selected but it makes no difference. How do I get it to show June's zero figure?

Thanks

Re: Null values in chart

PrashantSangle — Thu, 25 Sep 2014 10:26:25 GMT

Hi,

Uncheck supress Null Values and Supress Missing from Presentation tab

and Check Show all VAlues in dimension tab

Regards

Re: Null values in chart

Karl_Hart — Thu, 25 Sep 2014 10:35:35 GMT

Cheers Max, that adds Jun but it also add future months which I dont wish to show yet. Is there something in the set analysis I can do to remove those?

Thanks

Re: Null values in chart

Karl_Hart — Fri, 10 Oct 2014 07:27:47 GMT

The below gives me the correct results I need to show only valid months based on my selection, but also includes null values (Also I have the "Show All Values" unticked on the dimensions tab