Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Mike_Y
New Contributor III

Bar chart sorting order not correct - only legend order has problem

Hi guys,

I am having a very strange issue where my stacked bar chart dimension order is correct but the legend order is not.

I have implemented a customized sequence using the dual() function.

=if(bookingstatus = 'Unbooked',
 if(prioritised_to_date >=0 and prioritised_to_date <= 14,dual('1-14 Days',1),
 if(prioritised_to_date >=15 and prioritised_to_date <= 30,dual('15-30 Days',2),
 if(prioritised_to_date >=31 and prioritised_to_date <= 60,dual('31-60 Days',3),
 if(prioritised_to_date >=61 and prioritised_to_date <= 90,dual('61-90 Days',4),
 if(prioritised_to_date >=91 and prioritised_to_date <= 120,dual('91-120 Days',5),
 if(prioritised_to_date >=121 and prioritised_to_date <= 150,dual('121-150 Days',6),
 if(prioritised_to_date >150,dual('>150 Days',100)))))))))

 

Please find more details from the screenshot.

1.JPG

Can you help me solve this problem, please?

 

Have a good day.

1 Reply

Re: Bar chart sorting order not correct - only legend order has problem

Hi,

What sorting options you have selected under Sorting Tab?

 

Regards,

Kaushik Solanki