Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show all dates in a chart

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!

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

Not applicable
Author

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