Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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