Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Rolling 12 months - Custom calendar

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.

   

CategoryOct-17Nov-17Dec-17Jan-18Feb-18Mar-18Apr-18May-18Jun-18Jul-18Aug-18Sep-18CYTDPYTDVariance
New
Renewal

Kindly let me know if the requirement is unclear

Thanks,

Anupama Jagan

2 Replies
Highlighted
Contributor III
Contributor III

Hi Anupama Jagan,

Kindly refer the following Link for Rolling 12 Months Data .

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

Highlighted
Creator
Creator

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.