Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Price Difference Table Chart in Qlik Sense

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.