Cumulative Sort

[bharani8]

Hi Team - i need to sort the value in descending order by "Amt (In USD)" for the attached qlikview doc. Plz help

[devarasu07]

Hi,

Front end your can try with sortable agg feature

The sortable Aggr function is finally here!

back end script method,

Cumulative:

LOAD *,

  RangeSum(Peek('run_sum'), [USD (in $M's)]) as run_sum

Resident Temp

Order By [USD (in $M's)] desc;

[techvarun · Accepted solution]

Check the attached

[bharani8]

TY Varun! This is what i was looking for... Can u explain what u did to achieve this outcome?

[bharani8]

Will give a try on this.. Thanks!!

[techvarun]

Hi Bharani,

I applied the sort by expression (Sum([USD (in $M's)])) on your lowest dimension (Sales Product).

in this case the sum of [USD (in $M's)] automatically grouped and sorted per sales product and we can set it appear ascending or descending as per requirement.

Thanks,

Varun.

[bharani8]

ok Tks! Understood.. I have a case, where i dont have the lowest dimension.. What will be the way to sort for that?

[bharani8]

stalwar1‌ Can you plz help on sorting while we have more than 2 Dimensions in Straight table..

[sunny_talwar]

Not sure what you need help with? Is this a new question? This thread seems to be resolved already