Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anupamajagan
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
satish25
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)

anupamajagan
Creator
Creator
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.