topic sorting in a bar chart in QlikView

sorting in a bar chart

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

Hey All,

if I want to sort a bar chart by name

EXample:

Domain :

Lets say I want to show the bar chart

sort it like this

(sort the text as I want)

Hope you can help

Thank you,

Re: sorting in a bar chart

niclaz79 — Fri, 16 Jun 2017 13:34:02 GMT

Hi Mario,

There are multiple ways you can do this, either by having the fields be a dual type, meaning you can assign them both a numeric and string based value.

Or you can add another column that would contain the sorting value, eg:

SortValue Text

1, 'y'

2, 'b'

3, 'x'

4, 'a'

And then sort by Expression SortValue ascending.

Re: sorting in a bar chart

sunny_talwar — Fri, 16 Jun 2017 13:43:23 GMT

May be like this

=Match(DimensionField, 'y', 'b', 'x', 'a')