Vizlib pivot table - alternate strips and months in left and column

[cgaleaQlik]

Hi All,

I have 2 questions regarding a vizlib pivot table I've created in Qlik Sense.

1. The left hand column contains months over several years. However, my dataset does not contain data for every month ('missing months' in image below). Is there a way to fill in the missing months using the auto generated calendar in Qlik Sense.
2. Is it possible to include alternate strips based on the months (see image below).

 Thank you!!

 

[edwin]

you can build the calendar separate from your fact.  you normally need the lower and upper thresholds and you can generate your calendar from that as DATE is pretty much well defined dimension.

you may not be able to get eactly that picture using a pivot table, but to answer the question re strips - yes you can control the background color.  you can use the following to identify rows that go together based on Month:

aggr(nodistinct rowno(),Month)

[edwin · Accepted solution]

 is a sample pivot with stripes:

background color: if(odd(aggr(nodistinct rowno(),Month)),red(), blue())

[cgaleaQlik · Accepted solution]

Thanks Edwin - appreciate your help!! 

[edwin]

yw