Straight table sorting order differs between Excel and Qlik Sense despite identical multi-level sort configuration
Straight table sorting order differs between Excel and Qlik Sense despite identical multi-level sort configuration
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?
