topic Re: Line Chart - Show Null Values as Zero in a Month Dimension in QlikView

Line Chart - Show Null Values as Zero in a Month Dimension

Fri, 25 Jul 2014 03:27:55 GMT

Hello,

I have a line chart like the following:

Each line represents a specific Territory with a value for the months

The thing is that not all the months have a value. Some of them are null.

What I want is to show all months, whether they have a value or not, in the last case, I'd like to have a 0 for the value.

So that I'd see all the months and the corresponding value for every territory.

For that line chart I'm using:

COUNT ({$<FLAG_Anomaly={"With Anomaly"}>} DISTINCT ACCT_ID_COUNT)

COUNT ({$<FLAG_ANOMALY={"With Anomaly","No Anomaly"}>} DISTINCT ACCT_ID_COUNT)

But there are some months like January and February where the value is null...

Do you know how could I do that, to turn the value I get from the expression to 0?

Thank you!

Anonymous — Fri, 25 Jul 2014 03:45:26 GMT

Try creating a Master Calendar to fill in the null dates:

You can also avoid nulls in non date fields by using IF(LEN(TRIM( [Field Name] )) = 0,0,[Field Name])

sujeetsingh — Fri, 25 Jul 2014 04:29:56 GMT

Creating a master calender is the best way to deal with these presentations