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