topic Re: Sorting stacked Bar chart in QlikView

Sorting stacked Bar chart

BootCam — Sat, 16 Nov 2024 21:46:18 GMT

Hi,

I would like to sort the bar chart starting with a particular value in dimension (x-axis) and then the rest will be based on the value in the expression on descending order.

Is this possible?

Thanks,

Re: Sorting stacked Bar chart

hopkinsc — Wed, 05 Dec 2018 18:25:28 GMT

Try sorting by expression and use..

=match(FIELD,'VALUE') and change to descending

That should put the value you have entered at the top and the rest should follow

Re: Sorting stacked Bar chart

BootCam — Wed, 05 Dec 2018 19:02:32 GMT

Hi HopkinSC,

Actually i am trying to sort by the height(Value) of the Bars not what goes on top or bottom.

Thanks,

Re: Sorting stacked Bar chart

hopkinsc — Wed, 05 Dec 2018 19:21:08 GMT

Hi, can you give an example?

Re: Sorting stacked Bar chart

sujana1621 — Wed, 05 Dec 2018 22:48:36 GMT

In the sort tab, check the expression box and write your expression for which you would like to sort and select Desc.

Hope this works.

Re: Sorting stacked Bar chart

BootCam — Sun, 09 Dec 2018 03:58:30 GMT

Hi Sorry for the late reply.

On the X Axis i have the dimension values like this:

ABC_100_0, ABC_100_1, ABC_100_2, XYZ_100_0, PQR_100_1, DSG_100_2 etc.......

I would like to have the ABC_100_0 first, ABC_100_1 second ABC_100_2 as the third and rest sort doesn't matter.

Please note: the _100_ is a dynamic value

Thanks,