8 Replies Latest reply: Feb 28, 2018 6:12 AM by nagamani vadisala RSS

    Compare data with last 6 and 18th months

    nagamani vadisala

      i have data with two columns as the date and data1 columns as below


      date                data1

      01/01/2017     1



      I have to compare data1 in last 6 months and data1 in last 18 months. if sum of data1 in last 6 months is greater than last 18 months then i have to display as "well" in the qliksense report.


      For 18 months: we have to get first 18th months in last 24 months

      can anyone suggest