4 Replies Latest reply: Feb 23, 2016 2:04 AM by Jithu J RSS

    how to get null values in chart

    Jithu J

      how to get null values for particular week/month dimension with different metrics

       

      now I have two tables i.e. one is fact table and another one is time dimension

       

      now If load these two table it will do a join based on date .... now I want to plot a chart with last 12 weeks

       

      week will the dimension and I selected only top 12 weeks....  but when I use the measure number of created and use it the graph ..

       

      I am getting the only top 12 weeks which have values...

       

      Example : if I plot weeks between 1 to 12 .... it is showing 1 to 14 weeks where week3 and week 7 is missing since they don't have data..

      but I want to show exactly 1 to 12 though I don't have data for those weeks... I want to show this as '0'

       

      can any one help me with this?

       

      fact  :

      Capture.PNG

      Time Dimension :

          

      DateyearmonthYear
      1/5/2014201411
      1/6/2014201411
      1/7/2014201411
      1/8/2014201411
      1/9/2014201411
      1/10/2014201411
      1/11/2014201411
      1/12/2014201412
      1/13/2014201412
      1/14/2014201412
      1/15/2014201412
      1/16/2014201412
      1/17/2014201412
      1/18/2014201412
      1/19/2014201413
      1/20/2014201413
      1/21/2014201413
      1/22/2014201413
      1/23/2014201413
      1/24/2014201413
      1/25/2014201413
      1/26/2014201414
      1/27/2014201414
      1/28/2014201414
      1/29/2014201414
      1/30/2014201414
      1/31/2014201414
      2/1/2014201424
      2/2/2014201425
      2/3/2014201425
      2/4/2014201425
      2/5/2014201425
      2/6/2014201425
      2/7/2014201425
      2/8/2014201425
      2/9/2014201426
      2/10/2014201426
      2/11/2014201426
      2/12/2014201426
      2/13/2014201426
      2/14/2014201426
      2/15/2014201426
      2/16/2014201427
      2/17/2014201427
      2/18/2014201427
      2/19/2014201427
      2/20/2014201427
      2/21/2014201427
      2/22/2014201427
      2/23/2014201428
      2/24/2014201428
      2/25/2014201428
      2/26/2014201428
      2/27/2014201428
      2/28/2014201428
      3/1/2014201438
      3/2/2014201439
      3/3/2014201439
      3/4/2014201439
      3/5/2014201439
      3/6/2014201439
      3/7/2014201439
      3/8/2014201439
      3/9/20142014310
      3/10/20142014310
      3/11/20142014310
      3/12/20142014310
      3/13/20142014310
      3/14/20142014310
      3/15/20142014310
      3/16/20142014311
      3/17/20142014311
      3/18/20142014311
      3/19/20142014311
      3/20/20142014311
      3/21/20142014311
      3/22/20142014311
      3/23/20142014312
      3/24/20142014312
      3/25/20142014312
      3/26/20142014312
      3/27/20142014312
      3/28/20142014312
      3/29/20142014312
      3/30/20142014313
      3/31/20142014313
      4/1/20142014413
      4/2/20142014413
      4/3/20142014413
      4/4/20142014413
      4/5/20142014413
      4/6/20142014414
      4/7/20142014414
      4/8/20142014414
      4/9/20142014414
      4/10/20142014414
      4/11/20142014414
      4/12/20142014414
      4/13/20142014415
      4/14/20142014415
      4/15/20142014415
      4/16/20142014415
      4/17/20142014415
      4/18/20142014415
      4/19/20142014415
      4/20/20142014416
      4/21/20142014416
      4/22/20142014416
      4/23/20142014416
      4/24/20142014416
      4/25/20142014416
      4/26/20142014416
      4/27/20142014417
      4/28/20142014417
      4/29/20142014417
      4/30/20142014417
      5/1/20142014517
      5/2/20142014517
        • Re: how to get null values in chart
          Sunny Talwar

          Do you have master calendar in your application? If you do may be you just need to uncheck 'Suppress Zero Values' on the presentation tab. May be share a sample to show the problem you are facing.

            • Re: how to get null values in chart
              Jithu J

              Suppress Zero Values' option will be in qlikView but not in qlik sense.... can you let me know the equivalent in qlik sense... I have check the 'show zero values ' in data tab ... but that didn't worked.... there is no option check that in presentation -> x-axis tab....

               

              is this a limitation in qlik sense??

               

              because for few weeks I have zero data , The bar chart only shows the results that aren't 0..

               

              if you see in the below chart ... june data is missing  since the value =0.. here I want to show all possible month names though the result is 0

               

               

              Technically I don't have rows associated to month june in the fact table.

               

              But I have Jun listed in my master calendar

               

               

              Untitled.png