topic Expression with current/relative position in QlikView https://community.qlik.com/t5/QlikView/Expression-with-current-relative-position/m-p/625138#M548467 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a list of 50 measures, I need to change my pivot table, to add the ratio of each of this measure on [NET SALES].</P><P>To reference an expression, I can ether use its label ex: =[NET SALES] or its position = Column(1)</P><P></P><P>I assume I will have to add 50 entries in my pivot table, but I wish they share the same formula (that I can put later as a variable) such as </P><P>=Column(CurrentPosition-1)/[NET SALES]</P><P></P><P>How can I retrieve the current position of an expression?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 619px;"><TBODY><TR><TD class="xl25" height="17" width="240">NET SALES</TD><TD></TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Cost of Sales</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Cost of Sales]/[NET SALES]</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Warehousing</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Warehousing]/[NET SALES]</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Freight &amp; Delivery</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Freight &amp; Delivery]/[NET SALES]</TD></TR></TBODY></TABLE><P>...</P></BODY></HTML> Mon, 10 Feb 2014 04:19:07 GMT 2014-02-10T04:19:07Z Expression with current/relative position https://community.qlik.com/t5/QlikView/Expression-with-current-relative-position/m-p/625138#M548467 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a list of 50 measures, I need to change my pivot table, to add the ratio of each of this measure on [NET SALES].</P><P>To reference an expression, I can ether use its label ex: =[NET SALES] or its position = Column(1)</P><P></P><P>I assume I will have to add 50 entries in my pivot table, but I wish they share the same formula (that I can put later as a variable) such as </P><P>=Column(CurrentPosition-1)/[NET SALES]</P><P></P><P>How can I retrieve the current position of an expression?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 619px;"><TBODY><TR><TD class="xl25" height="17" width="240">NET SALES</TD><TD></TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Cost of Sales</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Cost of Sales]/[NET SALES]</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Warehousing</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Warehousing]/[NET SALES]</TD></TR><TR><TD class="xl24" height="17" style="border-top: none;">Freight &amp; Delivery</TD><TD></TD></TR><TR><TD class="xl26" height="17" style="border-top: none;">%NET SALES</TD><TD>=[Freight &amp; Delivery]/[NET SALES]</TD></TR></TBODY></TABLE><P>...</P></BODY></HTML> Mon, 10 Feb 2014 04:19:07 GMT https://community.qlik.com/t5/QlikView/Expression-with-current-relative-position/m-p/625138#M548467 2014-02-10T04:19:07Z Re: Expression with current/relative position https://community.qlik.com/t5/QlikView/Expression-with-current-relative-position/m-p/625139#M548468 <HTML><HEAD></HEAD><BODY><P>can you attache the sample app for the same?</P></BODY></HTML> Mon, 10 Feb 2014 09:59:07 GMT https://community.qlik.com/t5/QlikView/Expression-with-current-relative-position/m-p/625139#M548468 2014-02-10T09:59:07Z