Pivot Table: sort second dimension

[micheledenardi]

Good Morning everyone,

i'm trying, without success, to order the secon dimension of a pitvot table in descending order or Sum(Value).

I've already read lots of QlikCommunity posts and tried different solutions but it works only for the first dimension.

Can someone help me to order also the second dimension (Mat2) in descending order of Sum(Value)?

I want to sort it in the layout and not during the script load... You can find my SampleApp.qvf at this link. 

I'm going crazy

[juliensaintmaxent3113]

Hi,

i'm not sure  to understand your trouble but you want to order by descending value the second dimension .

if it's that, try this like the screenshot:

if it's not correct can you explain more details on your trouble?

Thx

[micheledenardi]

With your solution, if you try to scroll down the product 80478 you will see it's not sorted correctly because the highest sum(Value) for product 80478 is 123.

[juliensaintmaxent3113]

I'm so sorry, I don't see that.

What is your version of Qlik sense?

It's very weird because i try with concatenation of Mat1 and Mat2 and i have a good result 

And when i insert Mat2  table shows bad result

I don't understand why when i select a value in Mat1, the Order works.

Keep hoping to solve the trouble 🙂

[micheledenardi]

I'm using QlikSense Nov 2018 enterprise.

I've tried lots of formulas to get the correct results but i didn't find a solution yet.

I don't know why qlik sense didn't work correctly in this case.