topic Re: Sort Pivot Table in QlikView

Sort Pivot Table

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have a pivot table

Year against cars giving calculated value number of sales.

Now i can sort year and the cars but not the calculate value number of sales

is this possible and how can i sort?

e.g

2014 2013

fiat 200 150

opel 300 125

Mazda 500 100

Now i want to sort

2014 2013

Mazda 500 100

opel 300 125

fiat 200 150

Re: Sort Pivot Table

JonnyPoole — Fri, 21 Nov 2014 20:27:16 GMT

Would this work ?

Re: Sort Pivot Table

Fri, 21 Nov 2014 20:52:25 GMT

thx for your quick answer.

But i mean, sort the column number, also not model and not year but number sales.

Hope you understand what i mean.

Re: Sort Pivot Table

JonnyPoole — Fri, 21 Nov 2014 21:02:23 GMT

You mean sorting the models from top to bottom depending on the sales numbers in either the first or second column (and not the row total) ?

Re: Sort Pivot Table

Fri, 21 Nov 2014 21:07:17 GMT

yes

Re: Re: Sort Pivot Table

JonnyPoole — Fri, 21 Nov 2014 21:19:17 GMT

Here is my attempt...

Re: Re: Sort Pivot Table

Fri, 21 Nov 2014 21:28:27 GMT

Super. But it will not work with me.

Re: Sort Pivot Table

agomes1971 — Fri, 21 Nov 2014 23:41:29 GMT

Hi,

please have a look at this

How to use Button to show a data as an ascending order??

Regards

André Gomes

Re: Sort Pivot Table

Sat, 22 Nov 2014 00:26:56 GMT

You can't sort one dimension in two ways. So sorting by expression won't work afaik. You can use a straight table or add a calculated dimension to the pivot table and sort by that calculated dimension. You could also sort the Store dimension by Y-value, but that will not only sort the category dimension, but the Store dimension as well.

Re: Sort Pivot Table

JonnyPoole — Sat, 22 Nov 2014 03:30:49 GMT

Can you elaborate ?

Re: Sort Pivot Table

agomes1971 — Mon, 24 Nov 2014 10:34:35 GMT

Hi,

i saw another interesting post...

pivot table sorting by expression

Regards

André Gomes