topic Re: Sorting on Dimension basis in QlikView

Sorting on Dimension basis

Wed, 18 Feb 2015 12:34:04 GMT

Hi All,

I have a situation as mentioned in graph below.

The Dimension consist the similar Value (like Active <30 Days and others) as shown.

Problem is that , I am unable to sort it in Proper format. I would like to sort this as either Ascending or desecending. likr (<30 , >30 & <60, >60 & <90, >90).

Your help will be higly appricicated.

Thanks!

D J

Re: Sorting on Dimension basis

simenkg — Wed, 18 Feb 2015 12:37:30 GMT

How do you create your buckets?

If you create them in the script, then create another field that is the sort order and use that to sort.

If not then sort on expression and use something like =avg(ActiveDays)

Re: Sorting on Dimension basis

Wed, 18 Feb 2015 12:49:16 GMT

Thanks for your Help !!!

Regards,

D J