Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor 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
Valued Contributor

Re: Sorting Values in Stacked Area Chart not working as I wish

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

6 Replies
umartareen
Contributor

Re: Sorting Values in Stacked Area Chart not working as I wish

Hi,

Try swapping the dimension in the Data tab.

igdrazil
Contributor III

Re: Sorting Values in Stacked Area Chart not working as I wish

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

kopfüber nope.png

Regards

Chris

sfatoux72
Valued Contributor

Re: Sorting Values in Stacked Area Chart not working as I wish

Hi,

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

Regards

igdrazil
Contributor III

Re: Sorting Values in Stacked Area Chart not working as I wish

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


Regards

Chris

sfatoux72
Valued Contributor

Re: Sorting Values in Stacked Area Chart not working as I wish

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
Contributor III

Re: Sorting Values in Stacked Area Chart not working as I wish

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

Regards

Chris

Community Browser