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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negavtive Rank in the FirstSortedValue

I am trying to get the next and the previous value to the firstsortedvalue.

In the below expression, can I give a -ve number (<-1) to the rank to get the next value. If not, how do I get the next value. I can not have it in the script as the value is dynamic.

FirstSortedValue([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] value, sort_weight [,rank])


TIA.

Srikanth

11 Replies
Not applicable
Author

Thanks so much for the quick solution.

Not applicable
Author

Thanks a lot.