Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to Sort Pivot (column with formula) from largest to smallest percentage

Hi Guys,

Can you help me, how to sort an existing pivot column formula from largest to smallest percentage.

Please find attached the sample data.

Thanks & Regards,

Valdi

1 Solution

Accepted Solutions
satyadev_j
Valued Contributor

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Hi,

As I mentioned earlier, Copy/Paste your %YTD expression in sorting tab expression box and make the order descending.

Hope it helps you.

Satya

10 Replies
Not applicable

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Goto Sort Tab, Select Y Value, Descending.

Not applicable

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Y value descending.PNG.png

Result.PNG.png

satyadev_j
Valued Contributor

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Hi,

Copy the expression and paste it in sorting tab's expression box for Sales dimension. Make a sorting in descending order.

Another option, you can check "Y-value" by Descending order.

sort.PNG.png

Not applicable

Re: Re: How to Sort Pivot (column with formula) from largest to smallest percentage

i'm sorry, Please find attached, how to sort column % YTD

satyadev_j
Valued Contributor

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Hi,

As I mentioned earlier, Copy/Paste your %YTD expression in sorting tab expression box and make the order descending.

Hope it helps you.

Satya

Not applicable

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

PFA. Sorting by %YTD.

Not applicable

Re: Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Hi Satya,

your answer is correct, but I have a problem when the name of the sales "-" or null which is above the line, not in order of the percentage >.<

Not applicable

Re: How to Sort Pivot (column with formula) from largest to smallest percentage

i can't see any null or '-'. Can you attach a screenshot?

Not applicable

Re: Re: How to Sort Pivot (column with formula) from largest to smallest percentage

Hi Mr. Ramkumar & Mr.Satyadev

Thanks for your help

Community Browser