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

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

Tue, 24 Jun 2014 01:28:10 GMT

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

Tue, 24 Jun 2014 01:30:29 GMT

Goto Sort Tab, Select Y Value, Descending.

Tue, 24 Jun 2014 01:31:47 GMT

Anonymous — Tue, 24 Jun 2014 01:32:39 GMT

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.

Tue, 24 Jun 2014 01:55:16 GMT

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

Anonymous — Tue, 24 Jun 2014 02:05:14 GMT

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

Tue, 24 Jun 2014 02:11:33 GMT

PFA. Sorting by %YTD.

Tue, 24 Jun 2014 02:23:10 GMT

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 >.<

Tue, 24 Jun 2014 02:25:24 GMT

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

Tue, 24 Jun 2014 02:30:39 GMT

Hi Mr. Ramkumar & Mr.Satyadev

Thanks for your help

Anonymous — Tue, 24 Jun 2014 02:45:25 GMT

HI,

Yes, you are right. NULL value always displaying at the bottom. Best way to handle this to interpret these value as "NA" or space.

Thanks