topic Re: Correct sorting in a Bar Chart in QlikView

Correct sorting in a Bar Chart

Fri, 17 Jul 2015 08:17:24 GMT

Hey guys,

i build a bar chart with several objects and values based on a date. But now I want to have a sorting regarding to the date and not regarding to all values, like it is at the moment. How I have to fix my sorting configures?

Thanks !

Re: Correct sorting in a Bar Chart

MK_QSL — Fri, 17 Jul 2015 08:20:06 GMT

I can't see anything wrong.. The bars are already sorted based on data !
Am i missing something?

Re: Correct sorting in a Bar Chart

hic — Fri, 17 Jul 2015 08:29:03 GMT

So, you want to sort the 2nd dimension according to the expression Sum(Value) ? And use different sort orders within the different dates?

If so, I must unfortunately say that it is not possible. The sort orders are global for the entire object, and cannot be different within the different values of the 1st dimension.

HIC

Re: Correct sorting in a Bar Chart

Fri, 17 Jul 2015 08:31:30 GMT

Oh wrong example. Here You see at the first date that the Value '15' is "higher" then Value '16'.

... !

Re: Correct sorting in a Bar Chart

MK_QSL — Fri, 17 Jul 2015 08:33:16 GMT

Where?

Re: Correct sorting in a Bar Chart

Fri, 17 Jul 2015 08:39:45 GMT

In your example the Value 16 is assigned to Object C. But in the data there is no Object C with Value 16. Run the script and then you will see that 16 is become the position under the 15 again.

Tab:

LOAD * INLINE [

Datum, Objekt, Value

1.1.2015, A, 10

1.1.2015, B, 10

1.1.2015, C, 15

1.1.2015, D, 16

2.2.2015, A, 25

2.2.2015, B, 25

2.2.2015, C, 50

2.2.2015, D, 45

];

Re: Correct sorting in a Bar Chart

MK_QSL — Fri, 17 Jul 2015 08:45:54 GMT

Check this.

Re: Correct sorting in a Bar Chart

Fri, 17 Jul 2015 08:51:47 GMT

Okay now let´s have a look at the second bar chart. Value 50 is under value 45. This is not correct. Maybe Qlikview is not able to this?

Re: Correct sorting in a Bar Chart

MK_QSL — Fri, 17 Jul 2015 09:04:07 GMT

As Henric replied, you can't have different sort order for different bar in same chart. This is not possible in QlikView.