Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello Tang man, I have the request out to the team, I will update here once I hear back from them.
Mike T
Hello Tang man -
This is what I have found:
Most functions can be used in the script, in the UI or in both.
You can also review this comprehensive document which covers script syntax and visualization (UI) expressions.
http://help.qlik.com/sense/en-US/pdf/Script%20Syntax%20and%20Chart%20Functions%20Guide.pdf
Let me know if you have any questions.
Regards,
Mike T
Qlik
Hey Tang man here is another for your reference:
Hello Michael
Thank you very much for help. Those a very useful information for me. Thx for providing Great Support.