Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sorting in chart question

I have a chart using a cyclic group, one of the fields in the cyclic group is a date field.  What I need to be able to do is sort all the other fields in the cyclic group descending by the Y axis, and the date field (when selected) by the X axis.  I can only find ways to sort by either the X or Y.

Any ideas appreciated.

Bella

5 Replies
chiru_thota
Specialist
Specialist

You can use expression sorting.I used it in my application where I have Cyclic group.

Example:

=if(GetCurrentField(Calendar)='Calendar Month',sum(MonthSort),if(GetCurrentField(Calendar)='Calendar Week',SubField(CalendarWeek,'-',2)))

Cyclic Group Sorting.jpg

aveeeeeee7en
Specialist III
Specialist III

Hi Bella

You can do cyclic Group Sorting by using Document Properties:

1) Click Settings on Top of your Qlikview Window and select Document Properties

  or just Simply Press (Ctrl+Alt+D).

2) Go to Groups Tab.

3) There you see your Cyclic Groups which you have created.

4) Select any one of the Group and Press Edit Button present below.

5) After this, you will see Group Settings Window which is showing your Cyclic group used fields on the Right Hand Side.

6) Click Sort Orders Button present below.

7) Group Sort Order Window Opens up.

😎 Now you can do Sorting as you feel like on the basis of individual field level.

Hope that helps.

Further, See the Attachment.

Regards

Aviral Nag

Anonymous
Not applicable
Author

Thanks, I have done that but that only works for the axis that the cyclic group is on and works on the field names/titles which is what I want for the date field but I want the others to be sorted by the product of the field which is presented on the other axis.

Bella

sebastiandperei
Specialist
Specialist

Please send sample

Anonymous
Not applicable
Author

Sorry I can't strip out enough information for my employer to be comfortable with me posting the qvw so thanks for the effort but I will have to go with PlanB and create 2 bar charts.

Bella