Pivot: ordering by sum() of 2nd dimension within 1st dimension

[#1]

I'm using v10.

I searched the forums and found various posts about pivot ordering, but no solution seems to be applicable to my case.

I'm attaching a test doc showing my problem.

Basically I need to order dim2, within dim1, by sum of dim1/dim2 total, ie:

1st dim | 2nd dim |sum

a | white | 30
a | brown | 9
a | red | 7

b | red | 28
b | brown | 20
b | white | 19

So white is 1st in dim1, but is last in dim2.

Thanks

[johnw]

As of QV9 (I haven't checked QV10), I don't know of any way to do this. It seems to be a common question/complaint, and has been requested a couple of times on the customer portal as a product enhancement:

https://eu1.salesforce.com/ideas/viewIdea.apexp?id=087200000008T02

[llauses243]

Hi,

This is my offer, moreover see attach .rar

Good luck, Luis

[#4]

How do I access that url at salesforce.com? Is it something controlled by QlikView or is it independent from it (so that you need a different login).

BTW, I have access to "partner portal", but not to "customer portal", my support contacts tell me that being a partner I cannot access "customer portal".

Should I register with salesforce and that's it, everyone can see it if he's registered, or do I need to prove I'm a licensed QlikView user?

Thanks!

[#5]

Thanks llauses.

I understand the logic, but unfortunately my example was a generalization/semplification of my actual issue: in the real app I'm developing both group and cust can be filtered, and there's also filter based on date (year/month/week) so that at "script time" I cannot build a table for every possible combination of selections that could be possibly active at runtime.

I was looking for a general way to do it through some trick in chart expressions.

Ie, I tried adding Cust and Group ad expressions so that I can refer to them as column(n) and then using

sum( {<Prod= {$(=column(2))},Cust={$(=column(3))}>} Qty)

but it doesn't work, the $(=column(n)) stuff doesn't get evaluated.

[johnw]

Giulio wrote: BTW, I have access to "partner portal", but not to "customer portal", my support contacts tell me that being a partner I cannot access "customer portal".
Should I register with salesforce and that's it, everyone can see it if he's registered, or do I need to prove I'm a licensed QlikView user?

Sorry, no idea. I'm a customer, but I wasn't able to access it for a long time. Supposedly, you're supposed to just have access as a licensed customer, nothing special required. I had to bug QlikTech to get access, though, as something was wrong with my account or something like that.

I can understand why they wouldn't let customers access the partner portal, but I have no idea why they wouldn't let partners access the customer portal.

Anyway, there's nothing particularly interesting at the link. It's just a suggestion that we need the option of sorting in the context of the previous dimensions, and a bunch of people agreeing that this is a necessary feature.