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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
MVP
MVP

qSortIndicator issue

Hi,

in extensions very often I need to sort dimensions myself, at least for 2nd dimension. Hence I try to figure out what sorting is given by the user. The only thing I cannot detect is when a dimension is not sorted, means sorting by load order.

In that case according to documentation qSortIndicator should equal 'N' but it doesn't:

So my guess is this is an API bug. Is there any workaround?

- Ralf

Astrato.io Head of R&D
1 Solution

Accepted Solutions
ErikWetterberg

Hi Ralf,

You really need qSortCriterias, which is not included in the dimension info in the layout (that might be considered a bug). When you turn off sorting in the standard property panel, the client will still set qSortByLoadOrder to 1, like this:

Capture.PNG

So QIX engine still thinks its sorted (which it is..).

A workaround would be getting the properties and checking qSortCriterias.

Hope this helps

Erik Wetterberg

View solution in original post

2 Replies
ErikWetterberg

Hi Ralf,

You really need qSortCriterias, which is not included in the dimension info in the layout (that might be considered a bug). When you turn off sorting in the standard property panel, the client will still set qSortByLoadOrder to 1, like this:

Capture.PNG

So QIX engine still thinks its sorted (which it is..).

A workaround would be getting the properties and checking qSortCriterias.

Hope this helps

Erik Wetterberg

rbecher
MVP
MVP
Author

Thanks Erik,

I know and have used qSortCriterias before but thought qSortIndicator would be a more simple solution.

Astrato.io Head of R&D