topic Re: Issue with missing months in Canonical Calendar in QlikView

Issue with missing months in Canonical Calendar

Anonymous — Wed, 16 Nov 2016 04:45:49 GMT

I am using Canonical Calendar in my script and need to show only last 12 months . The graph shows missing months when plotted as is but i need to display the graph for only last 12 months. When I try to show last 12 months then the months where there is a blank value is not shown in the graph and is skipped.

I have used the below in the Dimensions.

=if(Month<MonthStart(today()) and Month>monthname(AddMonths(today(),-14)),Month)

Can anybody please help as to what is going wrong in my chart?

Re: Issue with missing months in Canonical Calendar

jonathandienst — Wed, 16 Nov 2016 06:08:41 GMT

Use set analysis filters in the chart expressions rather than a calculated dimension. I also add a month sequence number to my calendars which makes this type of analysis much simpler:

Define the field something like this in your calendar load:

(Year(tmpDate) - 2000) * 12 + Month(tmpDate) as MonthSequence,

Then use this in your expressions with Month as a dimension:

Sum({<MonthSequence = {">=$(=Max(MonthSequence) - 12)"}>} Value)

Turn off suppress zero values to see the 0 value months.