topic Help in sorting in QlikView

Help in sorting

ali_hijazi — Sat, 31 Dec 2016 17:12:13 GMT

Hello - check attached qvw file

I got a straight table and is giving correct result in terms of sorting

I'm sorting data by Due Date

However when I convert it to pivot table it no more sorts by due date as one of the records is not in the correct position

Please advise on how to make the sorting the same in the two charts (the pivot table is the one needed)

MK_QSL — Sat, 31 Dec 2016 17:25:00 GMT

In straight table, you can sort according to any column.

But in pivot table, you have to sort it first according to the first dimension, then according to the next, etc.

You cannot sort it any way you want.

check enclosed file.

ali_hijazi — Sat, 31 Dec 2016 17:26:42 GMT

then why there is an option to sort by expression in the sort tab?

why only record of invoice 83750 comes in the wrong place?

please advise

MK_QSL — Sat, 31 Dec 2016 17:28:42 GMT

check attachment in previous reply..

ali_hijazi — Sat, 31 Dec 2016 18:14:13 GMT

so we need to sort all previous dimensions by Due date

let me try it on all data

ali_hijazi — Sat, 31 Dec 2016 18:17:49 GMT

it didn't work on the original document

what might be wrong?

MK_QSL — Sun, 01 Jan 2017 17:05:21 GMT

provide your sample app.. As already said you can't sort same way as straight table in pivot table.

You need to sort by first dimension first and then 2nd dimension and so on..