Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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

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