0 Replies Latest reply: Feb 16, 2015 1:15 PM by Tang man RSS

    Price Difference Table Chart in Qlik Sense

    Tang man

      Dear Community

       

      I wonder how can I build a Price Difference Table in Qlik Sense. It is to show the Percentage price variance between Current price and Last price for parts.


      Calculation : [ ( Current price - Last price ) / Last PO price x 100% ]

       

      Part No.PriceDatePrice Difference
      ABC123410001/1/2015-
      ABC123415001/2/201550%
      ABC345615003/1/2015-
      ABC345613204/2/2015-12%
      BCD3455300016/1/2015-
      BCD3455300015/2/20150%
      ERT9999200020/2/2015-
      JSH767010005/1/2015-
      JSH767011002/2/201510%
      RTY8909300021/1/2015-
      RTY89093000.154/2/20150%
      TYU2435235013/1/12015-
      TYU2435250020/1/20156%
      TYU2435300015/2/201520%
      UIO898923504/1/2015-

       

      How can I set the expression in Measures for calculating Price Difference?

       

      Thank you very much. Please give me a helping hand.