Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
satish25
Creator
Creator

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
Not applicable
Author

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.