topic Re: Sorting in chart question in QlikView

Sorting in chart question

Anonymous — Sun, 02 Mar 2014 23:55:06 GMT

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

Re: Sorting in chart question

chiru_thota — Mon, 03 Mar 2014 02:00:24 GMT

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

Re: Sorting in chart question

aveeeeeee7en — Mon, 03 Mar 2014 03:04:42 GMT

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

Re: Sorting in chart question

Anonymous — Mon, 03 Mar 2014 03:16:46 GMT

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

Re: Sorting in chart question

sebastiandperei — Mon, 03 Mar 2014 03:53:09 GMT

Please send sample

Re: Sorting in chart question

Anonymous — Tue, 04 Mar 2014 20:40:04 GMT

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