topic Re: Auto Orderiing in Chart with Cyclic Groups in QlikView

Auto Orderiing in Chart with Cyclic Groups

Wed, 22 Jan 2014 10:55:51 GMT

I have a Chart (table) with Cyclic group witch looks like this:

Grouped field 1	Name	Price
1	A	12
2	B	15

And if I change the group value

Grouped field 2	Name	Price
T	A	20
R	B	7

I'd like to automatically sort by Name for Grouped field 1 selected and

I'd like to automatically sort by Price Desc for Grouped field 2 selected.

Is it possible?

Re: Auto Orderiing in Chart with Cyclic Groups

jonathandienst — Wed, 22 Jan 2014 11:02:02 GMT

From Document Properties | Groups, select the group in the Groups box. Then click Edit. Now click on Sort Orders. Select the first field and define the sort properties. Then select the second field and define the sort properties, and so on. Click OK (3 times) to save.

HTH

Jonathan

Re: Auto Orderiing in Chart with Cyclic Groups

Wed, 22 Jan 2014 11:07:03 GMT

You can use "Expression" in "order" tab, setting the currently shown field. You can know what's the current field of a group with GetCurrentField(groupname) function.

Formula should be similar to:

=GetCurrentField(groupname)

you can finally specify Ascending or Descending....

Regards,