Rolling 12 months - Custom calendar

[Anonymous]

Hi All,

I want to show the below table in Qliksense which is actually rolling 12 months trend. The calendar we are using is a custom calendar provided by the client. I want the column names and also the expressions change dynamically when a month is completed. Any help will be much appreciated. New and Renewal are the categories and we have to show the trend of premium.

Category

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Sep-18

CYTD

PYTD

Variance

New

Renewal

Kindly let me know if the requirement is unclear

Thanks,

Anupama Jagan

[satish25]

Hi Anupama Jagan,

Kindly refer the following Link for Rolling 12 Months Data .

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

[Anonymous]

No this uses Date and the addmonths function which will automatically align it to the normal calendar. In our project we are following a different calendar. Like this year starts from Dec 15th 2017 and not jan 1 2018. So the expressions used wont work in this requirement right.