topic Re: Sorting in a Pivot in QlikView

Sorting in a Pivot

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

I have a pivot table that i am trying to sort, i know sorting a pivot inst as easy as sorting a straight table and have tried to do it but can't get it to work. I guess its not possible but thought i'd ask her instead.

Basically, i have the month/year pivoted and i want to sort it by the expression descending.

so in the above i would want the 8.8 at the top of Nov 2018, I'm not interested in how the rest of the months are sorted, it just needs to be latest month.

I have attached an example.

Thanks

Re: Sorting in a Pivot

sunny_talwar — Thu, 06 Dec 2018 18:35:17 GMT

Something like this?

Re: Sorting in a Pivot

hopkinsc — Thu, 06 Dec 2018 18:48:05 GMT

Hi,

Thanks for the reply.

That's correct but its taking the Manager into consideration too. What i want is for it to just sort on Assigned User.

I have exported what you have done into excel and sorted the column there, so what i want is in the attached (i dont care about the nulls, so they can stay there)

Re: Sorting in a Pivot

sunny_talwar — Thu, 06 Dec 2018 18:53:25 GMT

In that case convert this into a straight table... because Pivot table groups the rows by the dimension above it. Which means all users who have the same Manger will come as a same chunk. The same is not the problem with a straight table 🙂

Best,
Sunny

Re: Sorting in a Pivot

hopkinsc — Thu, 06 Dec 2018 18:56:22 GMT

Yes that's what i thought, i just wasn't sure if there was a way to overcome that by some fancy syntax 🙂

I will use your previous example though, and the user can drag the Manager column to the right so it appears after the Assigned User column, that will then give them the result they are looking for.

Thanks for your help 🙂

Re: Sorting in a Pivot

sunny_talwar — Thu, 06 Dec 2018 18:58:13 GMT

Yes, that is def. one option... or this using straight table

Re: Sorting in a Pivot

hopkinsc — Thu, 06 Dec 2018 19:16:04 GMT

Yes, i will inform the users of the straight table option, the only issue with that is i guess as their data grows they will have more months.

Thanks very much for your help anyway, appreciated 🙂