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