Discussion Board for collaboration on QlikView Scripting.
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,
Go to Solution.
As I mentioned earlier, Copy/Paste your %YTD expression in sorting tab expression box and make the order descending.
Hope it helps you.
Goto Sort Tab, Select Y Value, Descending.
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.
i'm sorry, Please find attached, how to sort column % YTD
PFA. Sorting by %YTD.
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 >.<
i can't see any null or '-'. Can you attach a screenshot?
Hi Mr. Ramkumar & Mr.Satyadev
Thanks for your help