Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-09 12:52 PM

Using the Rank function from a list box

Hi All,

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:



Rank(sum(Return * StockQty))=round(count(distinct Date)*ConfidenceLevel)

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:

Rank(sum(Return * StockQty))=15

Could someone help me figure out how to use a formula correctly in the RHS of the Rank function?



634 Views
0 Likes
0 Replies