2 Replies Latest reply: Sep 10, 2018 1:53 AM by Anupama Jagan RSS

    Rolling 12 months - Custom calendar

    Anupama Jagan

      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