Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
padmaja_gade
Contributor III
Contributor III

Sorting Issue

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.

6 Replies
sinanozdemir
Specialist III
Specialist III

Like this:

Capture.PNG

padmaja_gade
Contributor III
Contributor III
Author

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:

Capture.PNG

Thanks,

sinanozdemir
Specialist III
Specialist III

Hopefully, got this right this time.

Capture.PNG

padmaja_gade
Contributor III
Contributor III
Author

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.

krishna_2644
Specialist III
Specialist III

This way?

sort.PNG

padmaja_gade
Contributor III
Contributor III
Author

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

Capture.PNG

Thanks