topic Re: Difference of two different fields in two different rows in QlikView https://community.qlik.com/t5/QlikView/Difference-of-two-different-fields-in-two-different-rows/m-p/533117#M1139950 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> maybe you could modify your script to get the previous stop reading value.</P></BODY></HTML> Wed, 09 Oct 2013 13:59:21 GMT bbi_mba_76 2013-10-09T13:59:21Z Difference of two different fields in two different rows https://community.qlik.com/t5/QlikView/Difference-of-two-different-fields-in-two-different-rows/m-p/533116#M1139949 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">How get</SPAN><SPAN class="apple-converted-space"> <SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">difference</SPAN><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> of ((A of Start Reading(08/10/2013)) - (A of Stop Reading(07/10/2013))</SPAN></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">for table given bellow </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border-style: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="91"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="108"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Start Reading</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="96"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Stop Reading</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="90"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">Date</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="91"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">A</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="108"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">5000</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="96"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: #548dd4; font-size: 10.0pt; font-family: 'Arial','sans-serif';">5200</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="90"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: #548dd4; font-size: 10.0pt; font-family: 'Arial','sans-serif';">07/10/2013</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="91"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">B</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="108"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">3800</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="96"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">4000</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="90"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">07/10/2013</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="91"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">A</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="108"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: #943634; font-size: 10.0pt; font-family: 'Arial','sans-serif';">5800</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="96"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">7000</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="90"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: #943634; font-size: 10.0pt; font-family: 'Arial','sans-serif';">08/10/2013</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="91"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">B</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="108"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">5300</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="96"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">8000</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="90"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">08/10/2013</SPAN></P></TD></TR></TBODY></TABLE><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P></BODY></HTML> Wed, 09 Oct 2013 10:46:42 GMT https://community.qlik.com/t5/QlikView/Difference-of-two-different-fields-in-two-different-rows/m-p/533116#M1139949 2013-10-09T10:46:42Z Re: Difference of two different fields in two different rows https://community.qlik.com/t5/QlikView/Difference-of-two-different-fields-in-two-different-rows/m-p/533117#M1139950 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> maybe you could modify your script to get the previous stop reading value.</P></BODY></HTML> Wed, 09 Oct 2013 13:59:21 GMT https://community.qlik.com/t5/QlikView/Difference-of-two-different-fields-in-two-different-rows/m-p/533117#M1139950 bbi_mba_76 2013-10-09T13:59:21Z