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.
Price
Date
Price Difference
ABC1234
1000
1/1/2015
-
ABC1234
1500
1/2/2015
50%
ABC3456
1500
3/1/2015
-
ABC3456
1320
4/2/2015
-12%
BCD3455
3000
16/1/2015
-
BCD3455
3000
15/2/2015
0%
ERT9999
2000
20/2/2015
-
JSH7670
1000
5/1/2015
-
JSH7670
1100
2/2/2015
10%
RTY8909
3000
21/1/2015
-
RTY8909
3000.15
4/2/2015
0%
TYU2435
2350
13/1/12015
-
TYU2435
2500
20/1/2015
6%
TYU2435
3000
15/2/2015
20%
UIO8989
2350
4/1/2015
-
How can I set the expression in Measures for calculating Price Difference?
Thank you very much. Please give me a helping hand.
