topic Re: Sorting Issue in QlikView

Sorting Issue

Anonymous — Wed, 04 Nov 2015 18:04:22 GMT

Hello,

I have a pivot table with three dimensions and an expressions. Each dimension has a different sorting. The first and second dimension if working correctly but the third one is not sorting correctly. I have attached sample file here.

Thanks for your help.

Re: Sorting Issue

sinanozdemir — Wed, 04 Nov 2015 19:33:51 GMT

Like this:

Re: Sorting Issue

Anonymous — Wed, 04 Nov 2015 20:16:24 GMT

No, Block Name should be sorted using column Course Sort, Exam Group should be sorted using ExamDate and Exam Name shouls be sorted using SortID

Like this:

Thanks,

Re: Sorting Issue

sinanozdemir — Wed, 04 Nov 2015 20:40:13 GMT

Hopefully, got this right this time.

Re: Sorting Issue

Anonymous — Wed, 04 Nov 2015 20:45:26 GMT

No, if you see the second Exam Group 'Written 2' the sort order is wrong.

I have tried so many different things here but the sorting is not working for Exam Names.

Re: Sorting Issue

Qrishna — Wed, 04 Nov 2015 20:56:31 GMT

This way?

Re: Sorting Issue

Anonymous — Wed, 04 Nov 2015 21:01:09 GMT

The Correct Sort Order is this: I did this in excel.

Thanks