Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Correct sorting in a Bar Chart

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 !

1 Solution

Accepted Solutions
Employee
Employee

Re: Correct sorting in a Bar Chart

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

8 Replies

Re: Correct sorting in a Bar Chart

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

Employee
Employee

Re: Correct sorting in a Bar Chart

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

Not applicable

Re: Correct sorting in a Bar Chart

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

Where?

Not applicable

Re: Correct sorting in a Bar Chart

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

Check this.

Not applicable

Re: Correct sorting in a Bar Chart

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

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

Community Browser