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: 
Abh1234
Contributor
Contributor

Qlik Sense Straight Table - Multiple Descending Sort Conditions

Hi,

I have a question regarding sorting behavior in a Qlik Sense Straight Table.

Scenario

I have a Straight Table with 10 columns.

Out of these 10 columns, 5 columns require descending sort conditions according to the business requirement.

Question

Does Qlik Sense support applying multiple sort conditions in a Straight Table?

For example:

  • Column A → Descending
  • Column B → Descending
  • Column C → Descending
  • Column D → Descending
  • Column E → Descending

Can Qlik Sense apply these sorting rules sequentially (primary sort, secondary sort, tertiary sort, etc.)?

Additional Questions

  1. Is there any limitation on the number of sort conditions that can be applied in a Straight Table?
  2. How does Qlik Sense decide which sort condition takes priority when multiple columns are sorted in descending order?
  3. If 5 descending sort conditions are configured, will the sorting work consistently after selections are made in the application?
  4. What is the recommended approach for implementing complex multi-column sorting in a Straight Table?

Any guidance, examples, or best practices would be appreciated.

Thank you!

Labels (1)
2 Replies
priscilarubim
Partner - Creator II
Partner - Creator II

Hi @Abh1234 !

I've wondered about this myself and honestly couldn't find a native configuration for multiple independent sort conditions. At least not in these official docs:

What the docs describe is a priority-based row sorting similar to ORDER BY A, B, C  in SQL, not independent descending rules per column simultaneously.

If anyone has found a way to achieve this, I'd love to know too! 🙂

mikaelsc
Specialist
Specialist

i'm probably not seeing the issue here... 

sort the columns as you like; in your specific required order. 

(use the sorting menu section of the table) 

if you are the owner/developper of the app, this will also be the default sorting in your table for other users... 

 

but other users can apply their own sorting by clicking on either which column when consulting the report. 

only after closing their session/reopening the app will the default sorting order be reapplied