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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
rbecher
Partner - Master III
Partner - Master III

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine
1 Solution

Accepted Solutions
ErikWetterberg
Master
Master

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
Master
Master

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
Partner - Master III
Partner - Master III
Author

Thanks Erik,

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine