topic Re: Give users the ability to sort in bar chart in QlikView

Give users the ability to sort in bar chart

Mon, 12 Jan 2015 19:09:10 GMT

I have a bar chart with one dimension and three expressions. I want to provide users the ability to display the dimension in the order they want. Is this possible.

For example if my dataset is

CITY SCORE

HOUSTON 100

BOSTON 50

New York 150

LA 20

I want to provide users the ability to order the cities on the X axis as they wish (ex: New York, Boston, LA, Houston). Is this posssible. My dataset is dynamic, the records for the dimension will change very frequently, so I am not able to hardcode the sort order, therefore want the users to choose.

Re: Give users the ability to sort in bar chart

sunny_talwar — Mon, 12 Jan 2015 19:25:51 GMT

Are there few ways you want them to sort City? For example few of the ways could be ascending, descending, by score etc. If there is a finite number of ways you want them to be able to sort it, then it might be possible. But if you want to be at user's discretion, then I am not sure if there is a way.

Others please contribute.

Best,

Re: Give users the ability to sort in bar chart

Mon, 12 Jan 2015 19:31:43 GMT

Is it possible to sort X axis in the order that dimension values are selected. As the user selects from the listbox, I want the dimension to be sorted in that order.

Re: Give users the ability to sort in bar chart

sunny_talwar — Mon, 12 Jan 2015 19:41:35 GMT

Unfortunately, I am not aware of a way to do it.

Best,

Re: Give users the ability to sort in bar chart

simospa — Mon, 12 Jan 2015 20:03:19 GMT

You could create 2 chart, one ordered in a way and one in the other (i.e.: one with cities ordered by descending and one ascending). Then you can put a simple list with two values and then in one condition you view a chart and hide the other and so for the second choise.

See the attachment.

Simone.

Re: Give users the ability to sort in bar chart

Mon, 12 Jan 2015 20:13:20 GMT

Thank you, but unfortunately this does not work for my requirements. This is still predefining the order.

Re: Give users the ability to sort in bar chart

MarcoWedel — Mon, 12 Jan 2015 21:18:32 GMT

Hi,

one possible solution could be:

hope this helps

regards

Marco

Re: Give users the ability to sort in bar chart

jonasheisterkam — Mon, 12 Jan 2015 21:46:02 GMT

Hi, here is a other approach.