Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

1 Reply
Gysbert_Wassenaar
Not applicable

Re: QlikSense Order By Expression Table

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.