topic Sorting Expression Column in QlikView

Sorting Expression Column

Wed, 27 Jan 2010 14:22:49 GMT

I have a SalesForecast pivot table with Region, Sales Person as dimension, sum(Sales) as Expression grouped by month. There's a row total at the end. I want the result is sorted by the Total asccendingly for each region. But I am not able to sort by the total expression. Anyone can help?

Region Sales Jan09 Feb09 Mar09 Apr09 May09 Jun09 .... Dec09 Total

ASIA John 30 25 40 50 55 350

Peter 10 15 20 10 10 120

EUROPE Rose 15 30 18 40 180

Alex 50 65 40 80 80 70 580

AW:Sorting Expression Column

Wed, 27 Jan 2010 14:45:04 GMT

Hi,

could you post an excample?

Alex:)

Sorting Expression Column

Wed, 27 Jan 2010 15:54:37 GMT

Hi Here's the example file.

I want to sort by the Total Sum per Sales Group regardless of Location order

SV:Re: Sorting Expression Column

Wed, 27 Jan 2010 16:09:39 GMT

The way to do it is to use the aggr functionality in the sorting expression.

Try sorting the dimension Sales on the following expression:


sum(aggr(sum(Unit),Sales))

Hope it helps!

//Jakob

SV:Re: Sorting Expression Column

Thu, 28 Jan 2010 03:07:17 GMT

Hi Jakob,

Still not able to sort in the way I want. I have tried this sorting expression in Sales or LOC dimensions, but both didn't work as well.

SV:Re: SV:Re: Sorting Expression Column

Thu, 28 Jan 2010 18:27:58 GMT

I have attached an example, based on your file, which shows what you want hopefully.

//Jakob

Sorting Expression Column

Fri, 29 Jan 2010 04:22:08 GMT

Hi, thanks for your help. But that's not the result I am looking for. Sorry that I am not explaning clearly. Here's the result I would like to see. Please help~~

Order I want to have for XGAXFAK_PAUX group which is order by the total inside each Sales group:
CLPUQ - 21
MXZLO - 21
CLSVE - 24
CL073 - 47
CLANF - 52
CLSAI - 379
PECLL - 589
CLIQQ - 758

Sorting Expression Column

Fri, 05 Feb 2010 09:40:34 GMT

Hi, any expert can help? Many thanks in advance...

Sorting Expression Column

Mon, 16 Aug 2010 05:40:05 GMT

You'll find that it is sorting based on total sales for the LOC not on the combination of Sales-LOC. in other words the dimension is ignored. i'm not sure this is a bug or by design...