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. | 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.