Straight table sorting order differs between Excel and Qlik Sense despite identical multi-level sort configuration

[adi_09]

I have implemented sorting in a Qlik Sense straight table with the following order:

Year (descending) → Month (descending) → Product Category (descending) → Solution Name (descending) → Product Name (ascending) → Call Number (descending)

The same sorting logic has been applied in Excel using multi-level sort for validation. However, the row order in Excel does not match the order displayed in Qlik Sense.

In Qlik Sense, the sorting is applied at the dimension level in the straight table properties, while Excel I have applied this - 

• Select your entire dataset
• Go to Data → Sort
• Click Add Level

Could someone clarify:
Why does Qlik Sense sorting order sometimes not match Excel sorted output even when the same hierarchy is used?

[Chanty4u]

Hi

Qlik first groups by the dimensions and then sorts the aggregated results.

Excel usually sorts the exported rows, not the aggregation process.

Check below 

All dimensions are sorted by Numeric or Text, not Load Order.

No dimension uses Sort by Expression.

Months use the same underlying numeric values.

The data exported from Qlik is the same aggregated dataset you're sorting in Excel (not the raw source data).