topic Controlling the Order in a chart in QlikView

Controlling the Order in a chart

Tue, 27 Jul 2010 05:14:04 GMT

Hi,

In the attached application, if I select a month, the order of the months in the chart isn't maintained.

Is there a way in which the months order in the chart retains, if a selection on months is made?

Controlling the Order in a chart

Anonymous — Tue, 27 Jul 2010 06:23:04 GMT

It looks like the original sort order is the "correct" one so you should be able to just remove the sort expression with the month number.. since when you select a month, the only available month number is the one attached to the selected value which gives that column the unexpected position.

Controlling the Order in a chart

Tue, 27 Jul 2010 07:44:25 GMT

Hi,

In Sort, instead of selecting, "expression", select Load Order - Original or Select "Default" and unclick on Text.

You will get what you want.

Happy Thoughts

Controlling the Order in a chart

Tue, 27 Jul 2010 07:54:16 GMT

Hi Ravi

I attached your modified application herewith.

Regards

Ashish