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

QlikSense Order By Expression Table

Hello,

I got a problem when i was try to use order by expression. Someone has a ideia about this problem?

print2.png

Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

As you can see in your screenshot there are multiple id values for a value of the other dimension. For example 'sad' has id's 5 and 6. Therefore id, which is really =only(id), returns null. Try max(id) instead. Or min(id) or avg(id). Dunno what suits you best.


talk is cheap, supply exceeds demand