2 Replies Latest reply: Apr 4, 2017 3:38 AM by Prashant k RSS

    How to keep my previous table intact in qliksense

    Prashant k

      i have a table as below , where i rank the suppliers region wise every month based on KPI value and weights allocated to KPI's  .

      . My supplier name and Average weights keep changing every month  .So may be a new supplier get added in the list on any month .

       

      1.How can i create script  to keep my previous month ranking data and also rank my supplier based on current month

      2.Show a comparison between previous ranking and current ranking.

       

         

      RegionSupplier NameAverage weights
      (Weight*KPI's)
      Rank region wise
      APACxyz17.751
      APACxyz27.52
      APACxyz35.73
      Europeabc44.41
      Americasghi56.31
      Americasghi66.052