Qlik Sales Comparison 1 is sorting in the wrong order

Owned by Julie Hanlon
Apr 10, 2018
1 min read

Problem

The Jiwa BI model in v11 has an issue where Qlik Sales Comparison 1 is a snap of that TAB with the dates that are in Alphabetical order, so all the June months are together, whereas it needs to be in the same order as the Overview TAB.  Qlik Sales Overview 1 is a snap of the Overview TAB with the dates that are in the correct order.

This problem has been fixed in Jiwa BI model v12 and above.

However, if you have a modified version of the model that you wish to continue working with, this is how you solve this error:

Solution

The Date sorting issue is as per the below screenshot. The two lines below need to be added in the Calendar tab.

//20180313 - Add New Sort
order by PeriodStart desc