Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem with sort in cyclic group

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

12 Replies
mov
Esteemed Contributor III

Re: Problem with sort in cyclic group

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

Not applicable

Re: Problem with sort in cyclic group

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.

country.PNGproduct01.PNGproduct02.PNGproduct03.PNG

sujeetsingh
Honored Contributor III

Re: Problem with sort in cyclic group

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

Not applicable

Re: Problem with sort in cyclic group

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).

prop.PNG

adhudson
Contributor II

Re: Problem with sort in cyclic group

Hi,

     Can you share a sample qvw?

Regards

Andrew Hudson

konda_haribabu
New Contributor II

Re: Problem with sort in cyclic group

Hi,

You can unchek the check box Allow interact sort and try.

Regards/Hari.

konda_haribabu
New Contributor II

Re: Problem with sort in cyclic group

Hi,

You can unchek the check box Allow interact sort and try.

Regards/Hari.

konda_haribabu
New Contributor II

Re: Problem with sort in cyclic group

Hi,

You can unchek the check box Allow interact sort and try.

Regards/Hari.

konda_haribabu
New Contributor II

Re: Problem with sort in cyclic group

Hi,

You can unchek the check box Allow interact sort and try.

Regards/Hari.

Community Browser