topic show % difference from one week to the next in QlikView https://community.qlik.com/t5/QlikView/show-difference-from-one-week-to-the-next/m-p/952220#M958222 <HTML><HEAD></HEAD><BODY><P>Hi below&nbsp; i have a very simple flat table in qlik sense when i select weeks 42 and 43 i would like to see the % difference either as a figure in the bottom</P><P></P><P>could this be done from a KPI&nbsp; chart ?</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Week</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Cost 1</STRONG></TH></TR><TR><TD style="padding: 2px;">42</TD><TD style="padding: 2px;">125</TD></TR><TR><TD style="padding: 2px;">44</TD><TD style="padding: 2px;">14</TD></TR></TBODY></TABLE><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 218px;"><TBODY><TR><TD height="20" style="background: #5b9bd5; border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 white white #5b9bd5; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="77">Week</TD><TD style="background: #5b9bd5; border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 white white; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="64">Trips</TD><TD style="background: #5b9bd5; border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 white white; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="77">Rev/Trip</TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">Week 42</TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">1068</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 497.02 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">Week 44</TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">949</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 401.25 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;" width="77">Diff </TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">119</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 95.77 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0.5pt 0.5pt; border-style: solid none solid solid; border-color: #5b9bd5 black #5b9bd5 #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">%</TD><TD align="right" style="border-width: 0.5pt 0px; border-style: solid none; border-color: #5b9bd5 black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">113%</TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #5b9bd5 #5b9bd5 #5b9bd5 black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">124%</TD></TR></TBODY></TABLE><P>any help is most appreciated</P><P></P><P>thanks </P></BODY></HTML> Fri, 06 Nov 2015 14:46:45 GMT 2015-11-06T14:46:45Z show % difference from one week to the next https://community.qlik.com/t5/QlikView/show-difference-from-one-week-to-the-next/m-p/952220#M958222 <HTML><HEAD></HEAD><BODY><P>Hi below&nbsp; i have a very simple flat table in qlik sense when i select weeks 42 and 43 i would like to see the % difference either as a figure in the bottom</P><P></P><P>could this be done from a KPI&nbsp; chart ?</P><P></P><TABLE border="1" class="jiveBorder" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" style="border: 1px solid #000000; border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Week</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Cost 1</STRONG></TH></TR><TR><TD style="padding: 2px;">42</TD><TD style="padding: 2px;">125</TD></TR><TR><TD style="padding: 2px;">44</TD><TD style="padding: 2px;">14</TD></TR></TBODY></TABLE><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 218px;"><TBODY><TR><TD height="20" style="background: #5b9bd5; border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 white white #5b9bd5; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="77">Week</TD><TD style="background: #5b9bd5; border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 white white; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="64">Trips</TD><TD style="background: #5b9bd5; border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 white white; color: white; font-family: Calibri; font-size: 11pt; font-weight: bold;" width="77">Rev/Trip</TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">Week 42</TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">1068</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 497.02 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">Week 44</TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">949</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 401.25 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0px 0.5pt; border-style: solid none none solid; border-color: #5b9bd5 black black #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;" width="77">Diff </TD><TD align="right" style="border-width: 0.5pt 0px 0px; border-style: solid none none; border-color: #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">119</TD><TD style="border-width: 0.5pt 0.5pt 0px 0px; border-style: solid solid none none; border-color: #5b9bd5 #5b9bd5 black black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;"> £ 95.77 </TD></TR><TR><TD height="20" style="border-width: 0.5pt 0px 0.5pt 0.5pt; border-style: solid none solid solid; border-color: #5b9bd5 black #5b9bd5 #5b9bd5; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">%</TD><TD align="right" style="border-width: 0.5pt 0px; border-style: solid none; border-color: #5b9bd5 black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">113%</TD><TD align="right" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: #5b9bd5 #5b9bd5 #5b9bd5 black; color: black; font-family: Calibri; font-size: 11pt; font-weight: 400;">124%</TD></TR></TBODY></TABLE><P>any help is most appreciated</P><P></P><P>thanks </P></BODY></HTML> Fri, 06 Nov 2015 14:46:45 GMT https://community.qlik.com/t5/QlikView/show-difference-from-one-week-to-the-next/m-p/952220#M958222 2015-11-06T14:46:45Z Re: show % difference from one week to the next https://community.qlik.com/t5/QlikView/show-difference-from-one-week-to-the-next/m-p/952221#M958223 <HTML><HEAD></HEAD><BODY><P>See attached example for a possible solution.</P></BODY></HTML> Mon, 09 Nov 2015 15:28:54 GMT https://community.qlik.com/t5/QlikView/show-difference-from-one-week-to-the-next/m-p/952221#M958223 Gysbert_Wassenaar 2015-11-09T15:28:54Z