topic Re: Using RowNo() to create a calculated expresssion in QlikView https://community.qlik.com/t5/QlikView/Using-RowNo-to-create-a-calculated-expresssion/m-p/424925#M567733 <HTML><HEAD></HEAD><BODY><P>Try chart inter records, namely top() function:</P><P></P><P><EM>=if(Expr=1,sum(Value), <STRONG>top(Value,9) / top(Value,4)</STRONG> ) </EM></P></BODY></HTML> Mon, 12 Nov 2012 15:20:57 GMT swuehl 2012-11-12T15:20:57Z Using RowNo() to create a calculated expresssion https://community.qlik.com/t5/QlikView/Using-RowNo-to-create-a-calculated-expresssion/m-p/424924#M567732 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Does anybody know if it is possible to create a calculated expression using the RowNo () function. I have a straight table that will always render the rows in the same position - I need to create a calculation based on the values in specific rows (the position of the row will NEVER change). See example, below - plus I have attached a .qvw to futher explain the issue - </P><P><IMG __jive_id="24984" class="jive-image-thumbnail jive-image" onclick="" alt="Screen_Dump.JPG" src="https://community.qlik.com/legacyfs/online/24984_Screen_Dump.JPG" width="450" /></P></BODY></HTML> Mon, 12 Nov 2012 15:17:23 GMT https://community.qlik.com/t5/QlikView/Using-RowNo-to-create-a-calculated-expresssion/m-p/424924#M567732 2012-11-12T15:17:23Z Re: Using RowNo() to create a calculated expresssion https://community.qlik.com/t5/QlikView/Using-RowNo-to-create-a-calculated-expresssion/m-p/424925#M567733 <HTML><HEAD></HEAD><BODY><P>Try chart inter records, namely top() function:</P><P></P><P><EM>=if(Expr=1,sum(Value), <STRONG>top(Value,9) / top(Value,4)</STRONG> ) </EM></P></BODY></HTML> Mon, 12 Nov 2012 15:20:57 GMT https://community.qlik.com/t5/QlikView/Using-RowNo-to-create-a-calculated-expresssion/m-p/424925#M567733 swuehl 2012-11-12T15:20:57Z