Price Difference Table chart in Qlik Sense

[#1]

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.

[Michael_Tarallo]

Hello Tang man, I have the request out to the team, I will update here once I hear back from them.

Mike T

[Michael_Tarallo]

Hello Tang man -

This is what I have found:

Most functions can be used in the script, in the UI or in both.

• Most functions (high percentage) can be used in both places
• Some can be used only in the script: Exists(), Peek(), Evaluate(), etc.
• Some can be used only in the UI: Above(), Below(), Aggr(), etc.

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

[Michael_Tarallo]

Hey Tang man here is another for your reference:

http://help.qlik.com/sense/en-US/online/#../Subsystems/WorkingWith/Content/ChartFunctions/UseFunctio...

http://help.qlik.com/sense/en-US/online/#../Subsystems/WorkingWith/Content/Scripting/FunctionsInScri...

[#5]

Hello Michael

Thank you very much for help. Those a very useful information for me. Thx for providing Great Support.