topic Price Difference Table Chart in Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Price-Difference-Table-Chart-in-Qlik-Sense/m-p/815729#M11261 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Dear Community</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I wonder how can I build a Price Difference Table in Qlik Sense. It is to show the <SPAN style="font-weight: inherit; font-style: inherit; font-size: 16px; font-family: Calibri, sans-serif; color: #575757;"><STRONG style="color: #ff0000;">Percentage price variance between Current price and Last price for <SPAN style="text-decoration: underline;">parts</SPAN></STRONG><SPAN style="color: #ff0000;">. </SPAN></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #575757;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #575757;">Calculation : [ ( Current price - Last price ) / Last PO price x 100% </STRONG><STRONG style="color: #575757; font-family: arial, helvetica, sans-serif; font-size: 10pt; line-height: 1.5em; font-style: inherit;">]</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 360px;"><TBODY><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt; width: 69pt;" width="92">Part No.</TD><TD style="width: 48pt;" width="64">Price</TD><TD style="width: 77pt;" width="102">Date</TD><TD style="width: 77pt;" width="102"><STRONG style=": ; color: #ff0000; font-size: 12pt; font-family: 'arial black', 'avant garde';">Price Difference</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">ABC1234</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">1/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">ABC1234</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1500</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">1/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">50%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;">ABC3456</TD><TD align="right">1500</TD><TD align="right" class="xl66">3/1/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;">ABC3456</TD><TD align="right">1320</TD><TD align="right" class="xl66">4/2/2015</TD><TD align="right" class="xl67" style="text-align: center;"><STRONG>-12%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">BCD3455</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">16/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">BCD3455</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">15/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">0%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD class="xl65" height="21" style="height: 15.75pt;">ERT9999</TD><TD align="right">2000</TD><TD align="right" class="xl66">20/2/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">JSH7670</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">5/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">JSH7670</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1100</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">2/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">10%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #575757;">RTY8909</SPAN></TD><TD align="right"><SPAN style="color: #575757;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #575757;">21/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #575757;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #575757;">RTY8909</SPAN></TD><TD align="right"><SPAN style="color: #575757;">3000.15</SPAN></TD><TD align="right" class="xl66" style="text-align: right;"><SPAN style="color: #575757;">4/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG>0%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">2350</SPAN></TD><TD class="xl68" style="text-align: right;"><SPAN style="color: #ff6600;">13/1/12015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">2500</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">20/1/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><SPAN style="color: #ff6600;"><STRONG>6%</STRONG></SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">15/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><SPAN style="color: #ff6600;"><STRONG>20%</STRONG></SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl64" height="21" style="height: 15.75pt;">UIO8989</TD><TD align="right">2350</TD><TD align="right" class="xl66">4/1/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR></TBODY></TABLE><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can I set the expression in <STRONG style="font-style: inherit; font-family: inherit;">Measures </STRONG>for calculating Price Difference<STRONG style="font-style: inherit; font-family: inherit;">?</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you very much. Please give me a helping hand.</P></BODY></HTML> Mon, 16 Feb 2015 18:18:54 GMT 2015-02-16T18:18:54Z Price Difference Table Chart in Qlik Sense https://community.qlik.com/t5/App-Development/Price-Difference-Table-Chart-in-Qlik-Sense/m-p/815729#M11261 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Dear Community</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I wonder how can I build a Price Difference Table in Qlik Sense. It is to show the <SPAN style="font-weight: inherit; font-style: inherit; font-size: 16px; font-family: Calibri, sans-serif; color: #575757;"><STRONG style="color: #ff0000;">Percentage price variance between Current price and Last price for <SPAN style="text-decoration: underline;">parts</SPAN></STRONG><SPAN style="color: #ff0000;">. </SPAN></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #575757;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #575757;">Calculation : [ ( Current price - Last price ) / Last PO price x 100% </STRONG><STRONG style="color: #575757; font-family: arial, helvetica, sans-serif; font-size: 10pt; line-height: 1.5em; font-style: inherit;">]</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 360px;"><TBODY><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt; width: 69pt;" width="92">Part No.</TD><TD style="width: 48pt;" width="64">Price</TD><TD style="width: 77pt;" width="102">Date</TD><TD style="width: 77pt;" width="102"><STRONG style=": ; color: #ff0000; font-size: 12pt; font-family: 'arial black', 'avant garde';">Price Difference</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">ABC1234</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">1/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">ABC1234</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1500</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">1/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">50%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;">ABC3456</TD><TD align="right">1500</TD><TD align="right" class="xl66">3/1/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;">ABC3456</TD><TD align="right">1320</TD><TD align="right" class="xl66">4/2/2015</TD><TD align="right" class="xl67" style="text-align: center;"><STRONG>-12%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">BCD3455</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">16/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">BCD3455</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">15/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">0%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD class="xl65" height="21" style="height: 15.75pt;">ERT9999</TD><TD align="right">2000</TD><TD align="right" class="xl66">20/2/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">JSH7670</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">5/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">JSH7670</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">1100</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">2/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG style=": ; color: #ff6600;">10%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #575757;">RTY8909</SPAN></TD><TD align="right"><SPAN style="color: #575757;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #575757;">21/1/2015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #575757;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD height="21" style="height: 15.75pt;"><SPAN style="color: #575757;">RTY8909</SPAN></TD><TD align="right"><SPAN style="color: #575757;">3000.15</SPAN></TD><TD align="right" class="xl66" style="text-align: right;"><SPAN style="color: #575757;">4/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><STRONG>0%</STRONG></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">2350</SPAN></TD><TD class="xl68" style="text-align: right;"><SPAN style="color: #ff6600;">13/1/12015</SPAN></TD><TD class="xl69" style="text-align: center;"><SPAN style="color: #ff6600;">-</SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">2500</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">20/1/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><SPAN style="color: #ff6600;"><STRONG>6%</STRONG></SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl63" height="21" style="height: 15.75pt;"><SPAN style="color: #ff6600;">TYU2435</SPAN></TD><TD align="right"><SPAN style="color: #ff6600;">3000</SPAN></TD><TD align="right" class="xl66"><SPAN style="color: #ff6600;">15/2/2015</SPAN></TD><TD align="right" class="xl67" style="text-align: center;"><SPAN style="color: #ff6600;"><STRONG>20%</STRONG></SPAN></TD></TR><TR style="height: 15.75pt;"><TD class="xl64" height="21" style="height: 15.75pt;">UIO8989</TD><TD align="right">2350</TD><TD align="right" class="xl66">4/1/2015</TD><TD class="xl69" style="text-align: center;">-</TD></TR></TBODY></TABLE><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can I set the expression in <STRONG style="font-style: inherit; font-family: inherit;">Measures </STRONG>for calculating Price Difference<STRONG style="font-style: inherit; font-family: inherit;">?</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you very much. Please give me a helping hand.</P></BODY></HTML> Mon, 16 Feb 2015 18:18:54 GMT https://community.qlik.com/t5/App-Development/Price-Difference-Table-Chart-in-Qlik-Sense/m-p/815729#M11261 2015-02-16T18:18:54Z