Discussion Board for collaboration related to QlikView App Development.
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.
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
Hopefully, got this right this time.
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.
The Correct Sort Order is this: I did this in excel.