Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
igdrazil
Creator III
Creator III

Sorting Values in Stacked Area Chart not working as I wish

Hi there, I have a problem with my area chart.

I can set it up as need but when i'm done it is headfirst (see picture) Kopfüber.png

The red parts should be at the bottom of the Chart and the light and "normal" blue ones should be on top.

To Data:

Dimensions:

-TimeField

-Field for different areas with 8 different values (e.g. working, change cube, etc)

Measure:

-sum(x)

i tried to swap sorting so it should be in the right order, only the bottom of the chart is changing (see next picture)kopfüber sort changed.png

It looks like only a part of the field changes its order.

I hope someone could help me. Thanks in advance.

Regards

Chris

P.S.: Things i don't want to do but worked in other cases with such a problem:

-adding a field with values and sort by expression to get the desired sort order.

1 Solution

Accepted Solutions
sfatoux72
Partner - Specialist
Partner - Specialist

Ok,

Your problem is just do to the fact that you don't have data for the first date for "Working" and it could not be include in the sort until the

2015-12-07 14_46_29-Qlik Sense Desktop.png

It will work if you add "0" for working instead of Null for the first date

For example, if I select only the date with no null data we could see the result that you want.

The dimension "value_string" is sorted alphabetical descending

2015-12-07 14_54_03-Qlik Sense Desktop.png

View solution in original post

6 Replies
umartareen
Creator II
Creator II

Hi,

Try swapping the dimension in the Data tab.

igdrazil
Creator III
Creator III
Author

sadly it's not that easy  I'll show you what it will be then:

kopfüber nope.png

Regards

Chris

sfatoux72
Partner - Specialist
Partner - Specialist

Hi,

could you share your app? It will be more easy to help you.

Regards

igdrazil
Creator III
Creator III
Author

Here is the test-app with the original Dataset (removed the loading script due to security issues)


Regards

Chris

sfatoux72
Partner - Specialist
Partner - Specialist

Ok,

Your problem is just do to the fact that you don't have data for the first date for "Working" and it could not be include in the sort until the

2015-12-07 14_46_29-Qlik Sense Desktop.png

It will work if you add "0" for working instead of Null for the first date

For example, if I select only the date with no null data we could see the result that you want.

The dimension "value_string" is sorted alphabetical descending

2015-12-07 14_54_03-Qlik Sense Desktop.png

igdrazil
Creator III
Creator III
Author

Thank you Sébastien! I will check my data for that.

Regards

Chris