topic Sorting by Expression in a Bar Chart in QlikView

Sorting by Expression in a Bar Chart

Wed, 25 Nov 2015 11:16:25 GMT

Hi guys,

Hopefully, this is a nice and easy one.

I have a bar chart with two dimensions, Year and Department.

I have one expression which is a simple sum i.e. Sum(Supplier_Cost).

I would like my bar chart to be sorted in ascending order by the expression above and also by Year.

I would like to see the least year (2010) appear first then other years in the axis and then I would like to see the supplier costs in ascending order in the bar chart.

I tried using the expression and using Rank in the sort tab, but it still doesn't work as expected.

Can you please let me know how to get this working?

Thanks

Re: Sorting by Expression in a Bar Chart

robert_mika — Wed, 25 Nov 2015 11:57:48 GMT

Could post a screenshot and/or your app?

Re: Sorting by Expression in a Bar Chart

avinashelite — Wed, 25 Nov 2015 12:10:44 GMT

Please share the sample qvw file

Re: Sorting by Expression in a Bar Chart

Wed, 25 Nov 2015 12:36:38 GMT

I'll try to post an image if I can.

It contains sensitive data, so even if I scramble it, I will probably be unable to share the app

Re: Sorting by Expression in a Bar Chart

buzzy996 — Wed, 25 Nov 2015 12:41:40 GMT

try tis way,

Re: Sorting by Expression in a Bar Chart

puttemans — Wed, 25 Nov 2015 12:44:30 GMT

Hi Shiva,

Are the same parameters selected when you select the Region dimension? Now you define those for the Year dimension.

Kind regards,

Johan

Re: Sorting by Expression in a Bar Chart

buzzy996 — Wed, 25 Nov 2015 12:48:33 GMT

in my case not,but again that depends on which dimension his first show on his chart!

Re: Sorting by Expression in a Bar Chart

Thu, 26 Nov 2015 10:22:40 GMT

Hi,

Apologies for the late reply.

I have attached an image of the chart with two dimensions and one expression and what i would like is to sort by ascending numerical value by Year.

Thanks