4 Replies Latest reply: Apr 17, 2017 2:21 PM by Chiwa1 Chiwa1 RSS

    Qlik Sense - Bar charts with constant time line - even with no data

    Chiwa1 Chiwa1

      Hello,

       

      I've looked for the answer across the web and across the two thread below but still an unanswered.

      bar charts time lines on Qlik Sense.

       

       

      I have 2 tables:

       

      Sales:

      Product

      ShipToCustomer

      Qnty

      DateShipped

       

      MasterCalendar:

      DateShipped

      Year

      Month

      Week

       

      I created two bar charts to show how many shipment were made per product per Month/week.

      I'm using Year-Month and Year-Week measures (for example 2017-03 is March and 2017-15 is the 15th week of 2017)

      problem is that if there are no sales to a product in a month or a week it doesn't show at all, and I would like it to show with Qnty zero (although none exists in the data set)

       

      I tried to add Sum(1) Sales * 0 but then all the month are shown and there is not filtering on the products at all.

      put simply, I want the timeline to remain constant and to allow filters by products and customer to take affect on the graph.

       

      can someone please enlighten me how can this be accomplished?

       

      How to retain hierarchy view of null values?

      Force showing all values on x-axis