Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-09-10 12:22 AM

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

989 Views
0 Likes
2 Replies
satish25
Contributor III
Contributor III
‎2018-09-10 12:41 AM

Hi Anupama Jagan,

Kindly refer the following Link for Rolling 12 Months Data .

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

915 Views
0 Likes
Anonymous
Not applicable
‎2018-09-10 01:53 AM
Author

In response to satish25

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.

915 Views
0 Likes