topic Re: Cyclic Group - sort the fields not the values in QlikView

Cyclic Group - sort the fields not the values

Mon, 20 Jan 2014 11:45:57 GMT

Hi !

I am searching for a way to sort a cyclic group. Not the values inside a field, but the order of the fields themselves.

For example:

CyclicGroup1:

Address

Name

i want the order to be this one always (now they are messed up)

Thanks!

Mor

vikasmahajan — Mon, 20 Jan 2014 11:51:08 GMT

Go to Cyclic Groups - Edit Groups ->Select Your Grp -> Click on Edit -> Right Corner Down Select -> Sort Order ->

Give Sort order as per your requirement.

Hope this help you. pfa screen short for the same.

Vikas

Mon, 20 Jan 2014 11:56:45 GMT

but this sorting is per field isnt it?

in your screen the Quarters in the field quarter will b sorted by text.

i want that the orders of the fields in the group will be a-z

vikasmahajan — Mon, 20 Jan 2014 12:03:10 GMT

You can select each field and set sort order please try.

Vikas

Mon, 20 Jan 2014 12:10:39 GMT

There is no way to sort the field name in cg automatically.

we need to sort the field manually using promote and demote buttons..

Regards,

Kabilan K.

Anonymous — Mon, 20 Jan 2014 19:29:44 GMT

The order of the fields in groups are defined in Group Settings. Select a field on the right, and use Promote/Demote.