topic Re: Sorting in drill down chart in QlikView

Sorting in drill down chart

manisha_uit — Tue, 09 Oct 2012 08:05:26 GMT

Hi,

I have a drill down chart - the dimensions used are Month -> Reject Type -> Date -> Item

Currently it is sorted by Month

But my user wants all the dimensions to be sorted separately like:

Month -> Jan, Feb, Mar......

Reject Type -> desc to asc

Date -> Oct-01, Oct-02, Oct-03.......

Item -> desc to asc

Is there any option where i can customize the sort order for each dimension?

Thanks

Manisha

Re: Sorting in drill down chart

Tue, 09 Oct 2012 08:13:10 GMT

Hi,

did u make group for that right.......if u edit that group then there is an option for Sort Order...just check....& select Dimension & apply sort order for that particular Dimension..

Re: Sorting in drill down chart

manisha_uit — Tue, 09 Oct 2012 08:40:24 GMT

Hi,

Yeah i've tried doing that...

The sort order which i've used are:

Month -> Expression to sort it by months

Reject Type -> Frequency

Date -> Numeric value

Item -> Frequency

But no effect on the graphs

Re: Sorting in drill down chart

MayilVahanan — Tue, 09 Oct 2012 09:05:06 GMT

Try like this

Edit that group then there is an option for Sort Order...just check....& select Dimension & apply sort order for that particular Dimension..

Use Month -> Load Order ascending

Reject Type -> Text Z-A

Date -> Text Z-A or load order asc

Item ->Text Z-A

Hope that helps

Re: Sorting in drill down chart

Tue, 04 Dec 2012 02:12:33 GMT

You might be experiencing the same thing I just fought through, it was not enough to set the sort order for each attribute in the Drill-Down Group only. I also had to deselect the chart itself from sorting on the Y-value.

Chris

Re: Sorting in drill down chart

Fri, 11 Apr 2014 13:24:32 GMT

To reflect sorting on a drill down dimension, you have to first remove the sort applied on the group itself, then drill down dimensions will start reflecting.

Go to Chart Properties --> Sort Tab ----> select dimension ---> uncheck all sort by ----> OK

then

Go to Chart Properties --> Dimension Tab ---> Edit Group button ---> Edit button ---> Sort Orders button ---> Select a field and opt your sort.

Re: Sorting in drill down chart

panwipa2528 — Tue, 14 Nov 2017 03:02:14 GMT

Thank you for your help. That's correct for me.