topic Re: Pivot Table: sort second dimension in App Development

Pivot Table: sort second dimension

micheledenardi — Sat, 16 Nov 2024 21:47:21 GMT

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

Re: Pivot Table: sort second dimension

juliensaintmaxent3113 — Mon, 03 Dec 2018 15:59:24 GMT

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

Re: Pivot Table: sort second dimension

micheledenardi — Mon, 03 Dec 2018 16:05:43 GMT

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.

Re: Pivot Table: sort second dimension

juliensaintmaxent3113 — Mon, 03 Dec 2018 16:51:02 GMT

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 🙂

Re: Pivot Table: sort second dimension

micheledenardi — Mon, 03 Dec 2018 16:57:20 GMT

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.