Accumulation in Bar chart - null value display

[Krish]

I am creating a stacked bar chart in QlikSense and using full Accumulation based on dimension. The X axis has Month as dimension. There are few values which are null/zero in a particular month. I am trying to show the same number as previous month for that value even if it is zero in current month.

Say for example, value for X is 100 in Jan, 0 in feb and 2 more added in Mar (102 is the total accumulated value in March), I want to show the data as 100 in Jan & Feb and 102 in March. How can this be achieved?

[vikasmahajan · Accepted solution]

Hi,

Did you implement Master Calendar ?

MasterCalendar:
LOAD
    OrderDate AS OrderDate,
    WEEK(OrderDate) AS Week,
    YEAR(OrderDate) AS Year,
    MONTH(OrderDate) AS Month,
    DAY(OrderDate) AS Day,
    WEEKDAY (OrderDate) AS Weekday,
    'Q' & CEIL(MONTH(OrderDate) / 3) AS Quarter,
    DATE(MONTHSTART(OrderDate), 'MMM-YYYY') AS MonthYear,
    WEEK(OrderDate) & '-' & YEAR(OrderDate) AS WeekYear ;

Load
  Date(MinOrderDate+IterNo()-1) as OrderDate
While MinOrderDate+IterNo()-1  <= MaxOrderDate;
  
LOAD
    Date(MIN(FieldValue('OrderDate',recno()))) AS MinOrderDate,
    Date(MAX(FieldValue('OrderDate',recno()))) AS MaxOrderDate
autogenerate FieldValueCount('OrderDate');

[Krish]

Hi Vikas,

 Thank you for your response. One quick question, will the master calendar resolve work in Quarter as well? If the data is 100 in Q1 and 0 in Q2, but I want that to display as 100 in Q1 and Q2.

[vikasmahajan]

yes , Master calendar purpose is to show 0 zero values for those dates where we don't have sales entry.

[Krish]

But I cannot use this date field in Master calendar as there is another field used from the source. The same is working in QlikView when Full Accumulation checkbox is selected at measure level, but its not the case in Qliksense.

[Krish]

I did try using Master calendar for that date field and tested, but the result is still the same. I do not see the previous month's values for the dimension when current month is 0