topic Show all dates in a chart in QlikView

Show all dates in a chart

Tue, 06 Nov 2012 10:19:18 GMT

Hi,

I want to show all dates in a chart even where its no sales.

This is what I have:

Table 1 - Sales
- DateID (YYYY-MM-DD)
- SalesDate
- NumOfSales
Table 2 - Calendar
- DateID (YYYY-MM-DD)
- CalendarDate
- Year
- Month
- Day

The Table 1 includes only the SalesDate with sales, otherwise the date won't exist. This tables is the associated with Table 2 with the date as key. The table CalendarDate is all dates that exists.

I my chart I'm using CalendarDate as dimension and the sum of NumOfSales as expression. But the chart will leave out CalendarDates with no sales. How can I show all CalendarDates during that period, even the dates with no sales?

Thanks ahead!

Re: Show all dates in a chart

jagan — Tue, 06 Nov 2012 11:07:56 GMT

Hi,

In Presentation tab Uncheck the "Supress zero values" option. Hope attached file helps you.

Regards,

Jagan.

Re: Show all dates in a chart

Tue, 06 Nov 2012 12:48:30 GMT

Hi,

It didn't work. I think I need to add more information to this question.

In the Table 1 there is also a SalesType indicating the type of the sales. For at chosen period (Year and Month from Table 2) and with a specific SalesType there is some SalesDates without any sales.

There is no difference when I'm unchecking the "Supress zero value".

When I place the field SalesDate on the sheet, I can see the missing dates but they are grey - no relation to the selection.

Is there another way to show the missing dates?

Thanks