topic Re: Cumulative Sort in QlikView

Cumulative Sort

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Cumulative Sort

devarasu07 — Mon, 04 Sep 2017 06:47:01 GMT

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;

Re: Cumulative Sort

techvarun — Mon, 04 Sep 2017 06:53:11 GMT

Check the attached

Re: Cumulative Sort

bharani8 — Mon, 04 Sep 2017 07:02:34 GMT

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

Re: Cumulative Sort

bharani8 — Mon, 04 Sep 2017 07:03:04 GMT

Will give a try on this.. Thanks!!

Re: Cumulative Sort

techvarun — Mon, 04 Sep 2017 09:01:40 GMT

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.

Re: Cumulative Sort

bharani8 — Mon, 04 Sep 2017 11:23:56 GMT

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

Re: Cumulative Sort

bharani8 — Mon, 04 Sep 2017 13:09:12 GMT

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

Re: Cumulative Sort

sunny_talwar — Wed, 06 Sep 2017 00:46:59 GMT

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