topic Re: Pivot Table sorting by value is inactive. in QlikView

Pivot Table sorting by value is inactive.

fatihtomruk — Fri, 12 Feb 2016 05:59:09 GMT

Hi,

I have a pivot table and there are there dimentions and four expressions. I want to sort the expression by values from largest to smallest.

Bu at the sort tab, Y-value's tick is inactive. Please help.

Fatih Tomruk

MayilVahanan — Fri, 12 Feb 2016 09:08:19 GMT

In Pivot table, Y - Value sort is enable for first dimension only.

Anonymous — Fri, 12 Feb 2016 09:15:18 GMT

Go to sort tab and in that have the expression to give the field name and it sort

jagan — Fri, 12 Feb 2016 09:30:24 GMT

Hi,

It is available for first Dimension only, instead of that you can use Expression and give your expression there.

Regards,

Jagan.

fatihtomruk — Fri, 12 Feb 2016 10:06:09 GMT

Yes,

I wrote a formula in the Expression sort. So It worked.

Thank you.

Best regards.

Fatih Tomruk.