topic Re: Problem with sort in cyclic group in QlikView

Problem with sort in cyclic group

Wed, 10 Oct 2012 10:32:07 GMT

Hello,

I read a lot of comments here, but nothing works.

I have Cyclic Group, where is Country (sorted by load order) and Product (sorted by Name) and other product variations sorted also by name. But Products are not sorted by name. I tried to set this in Document properties, but not works. When I use Override option and select Sort by Name, than Product is sorted by name, but Country not by Load order. It seems like load order from country, which is first in group gives load order to products.

Thanks for any help!

Mirek

Re: Problem with sort in cyclic group

Anonymous — Wed, 10 Oct 2012 15:34:52 GMT

Mirek,

When creating a group, the sort order is defined in the Group Settings, button "Sort Orders...". It is not clear from your description if you've done this.

Regards,

Michael

Re: Problem with sort in cyclic group

Thu, 11 Oct 2012 06:55:45 GMT

Hello Michael,

yes I did this.

"I have Cyclic Group, where is Country (sorted by load order) and Product (sorted by Name)..."

Problem is that Country IS sorted by "load order", but Product by "name" not.

Re: Problem with sort in cyclic group

sujeetsingh — Thu, 11 Oct 2012 06:58:43 GMT

Why dont you see the option of short in charts properties may be it work!!!!

Re: Problem with sort in cyclic group

Thu, 11 Oct 2012 07:02:32 GMT

Yes I could, but then I will have one sort rule for all dimensions in group. And I want sort Country by load order and products by text (name).

Re: Problem with sort in cyclic group

adhudson — Thu, 11 Oct 2012 07:07:06 GMT

Hi,

Can you share a sample qvw?

Regards

Andrew Hudson

Re: Problem with sort in cyclic group

konda_haribabu — Thu, 11 Oct 2012 07:37:18 GMT

Hi,