Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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.

Community Browser