topic Using the Rank function from a list box in QlikView https://community.qlik.com/t5/QlikView/Using-the-Rank-function-from-a-list-box/m-p/312024#M1197457 <HTML><HEAD></HEAD><BODY><P><I></I></P><P>Hi All,</P><P>I am trying to use the rank function to get a specific value from a list box. Below is the current formula I am using:</P><P></P><BR /><BR /> <P>Rank(sum(Return * StockQty))=round(count(distinct Date)*<B><I>ConfidenceLevel)</I></B></P><P>where Return, StockQty and Date are all data lists, and ConfidenceLevel is an input value from a slider. This formula should come back with a value of 0 for where the two are not equal, and -1 for where they are. The RHS of the equation is simply calculating the nth value of the list to match. I am unfortunately unable to get the correct value this way. I can, however, get it if I just plug in a value as such:</P><P></P><P><STRONG><EM>Rank</EM></STRONG>(sum(Return * StockQty))=15</P><P>Could someone help me figure out how to use a formula correctly in the RHS of the Rank function?</P><BR /><BR /> <P style="font-style: italic"></P><P></P></BODY></HTML> Wed, 09 Mar 2011 17:52:56 GMT 2011-03-09T17:52:56Z Using the Rank function from a list box https://community.qlik.com/t5/QlikView/Using-the-Rank-function-from-a-list-box/m-p/312024#M1197457 <HTML><HEAD></HEAD><BODY><P><I></I></P><P>Hi All,</P><P>I am trying to use the rank function to get a specific value from a list box. Below is the current formula I am using:</P><P></P><BR /><BR /> <P>Rank(sum(Return * StockQty))=round(count(distinct Date)*<B><I>ConfidenceLevel)</I></B></P><P>where Return, StockQty and Date are all data lists, and ConfidenceLevel is an input value from a slider. This formula should come back with a value of 0 for where the two are not equal, and -1 for where they are. The RHS of the equation is simply calculating the nth value of the list to match. I am unfortunately unable to get the correct value this way. I can, however, get it if I just plug in a value as such:</P><P></P><P><STRONG><EM>Rank</EM></STRONG>(sum(Return * StockQty))=15</P><P>Could someone help me figure out how to use a formula correctly in the RHS of the Rank function?</P><BR /><BR /> <P style="font-style: italic"></P><P></P></BODY></HTML> Wed, 09 Mar 2011 17:52:56 GMT https://community.qlik.com/t5/QlikView/Using-the-Rank-function-from-a-list-box/m-p/312024#M1197457 2011-03-09T17:52:56Z