topic Re: Cyclic group sort order in QlikView

Cyclic group sort order

Wed, 23 Nov 2011 15:20:30 GMT

Hi,

I have problems with sorting in a cyclig group when i use it as a dimension in a chart.

In the exampe attach, i create 2 ciclyc group. Both has every field order by descending frecuency .

I have problems when i use the dimension in a chart.

If i use it as the 1st Dimension (Country Cyclic Group in Sample Sample 1 and 3 - Product Type Cycli in sample 2), the order is wrong, is ascending.

If i use it as the 2nd dimension (Country Cyclic Group in Sample 5 - Product Tipe Cyclic in sample 3 and 4 ) , the order is OK.

But the problem is only with the cyclic group, because if i change the cyclic group for the dimension (Country in sample 4 (instead of contry ciclic group in sample 3)), the order is OK, its descending.

Anyone know if this is a bug or what is happening?

Thanks

Gaston

Re: Cyclic group sort order

Sokkorn — Mon, 28 Nov 2011 07:56:54 GMT

Hi Gaston,

Try this method: Goto Settings ==> Document Properties ==> Groups ==> Select Group Name ==> Click Edit ==> Click Sort Order ==> Select Fields and uncheck Frequency or use sort with expression.

See more in attached file.

Let me know if this one help you.

Regards,

Sokkorn

Re: Cyclic group sort order

Thu, 01 Dec 2011 12:02:05 GMT

Excelent, Thats Works!

Re: Cyclic group sort order

vinod22kv — Wed, 30 May 2018 10:20:03 GMT

Thanks for your post.....