Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
Mike_Y
New Contributor

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