topic Logic required in QlikView https://community.qlik.com/t5/QlikView/Logic-required/m-p/71856#M786209 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>please help me in building below logic</P><P></P><P>I need last column</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD class="xl63" height="20" width="64">A</TD><TD class="xl63" style="border-left: none;" width="64">B</TD><TD class="xl63" style="border-left: none;" width="64">C</TD><TD class="xl63" style="border-left: none;" width="64">Result</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Cat</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">10</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Tiger</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">54</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">2</TD><TD class="xl67" style="border-top: none; border-left: none;">10 Divide by 2</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Dog</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">3</TD><TD class="xl66" style="border-top: none; border-left: none;">(10 Divide by 2)/3</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Rabbit</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">34</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">4</TD><TD class="xl66" style="border-top: none; border-left: none;">((10 Divide by 2)/3)/4</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Pug Boss</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">43</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">5</TD><TD class="xl66" style="border-top: none; border-left: none;">(((10 Divide by 2)/3)/4)/5</TD></TR></TBODY></TABLE><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT shiveshsingh 2020-11-25T16:16:04Z Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/71856#M786209 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P></P><P>please help me in building below logic</P><P></P><P>I need last column</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px;"><TBODY><TR><TD class="xl63" height="20" width="64">A</TD><TD class="xl63" style="border-left: none;" width="64">B</TD><TD class="xl63" style="border-left: none;" width="64">C</TD><TD class="xl63" style="border-left: none;" width="64">Result</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Cat</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">10</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Tiger</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">54</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">2</TD><TD class="xl67" style="border-top: none; border-left: none;">10 Divide by 2</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Dog</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">56</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">3</TD><TD class="xl66" style="border-top: none; border-left: none;">(10 Divide by 2)/3</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Rabbit</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">34</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">4</TD><TD class="xl66" style="border-top: none; border-left: none;">((10 Divide by 2)/3)/4</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;" width="64">Pug Boss</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">43</TD><TD class="xl65" style="border-top: none; border-left: none;" width="64">5</TD><TD class="xl66" style="border-top: none; border-left: none;">(((10 Divide by 2)/3)/4)/5</TD></TR></TBODY></TABLE><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/71856#M786209 shiveshsingh 2020-11-25T16:16:04Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/71857#M786210 <HTML><HEAD></HEAD><BODY><P>=(Result / Alt(above(Result),1))</P></BODY></HTML> Thu, 22 Feb 2018 12:48:09 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/71857#M786210 suryaa30 2018-02-22T12:48:09Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/71858#M786211 <HTML><HEAD></HEAD><BODY><P>Not working</P></BODY></HTML> Thu, 22 Feb 2018 12:53:24 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/71858#M786211 shiveshsingh 2018-02-22T12:53:24Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/71859#M786212 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=If(RowNo() = 1, B, Above(Result)/C)</STRONG></P><P></P><P>or this</P><P></P><P><STRONG>=If(RowNo() = 1, B, Above(Column(1))/C)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194187_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Thu, 22 Feb 2018 13:01:45 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/71859#M786212 sunny_talwar 2018-02-22T13:01:45Z Re: Logic required https://community.qlik.com/t5/QlikView/Logic-required/m-p/71860#M786213 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny, got my mistake. small bracket played all the game&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Feb 2018 13:04:55 GMT https://community.qlik.com/t5/QlikView/Logic-required/m-p/71860#M786213 shiveshsingh 2018-02-22T13:04:55Z