Running Total as a Dimension

[phaneendra_kunc]

I am using QV 12 with new "The sortable Aggr function is finally here!"

But still i am having issue in getting the result. I know i am missing something here.

What do i need: Running total as dimension and cant be done in script. Also can not add sort order or order by clauses in script.

     * long story short i am using Qlik + Jethro + Data Discovery" which this combination has very limited functions i can write.

Challenge: Sorting the values and Summing up in proper order.

Thanks in Advance.

Phani

[sunny_talwar]

What is the sort order you are looking for Phani?

[sunny_talwar]

Is it the descending order of Sum(Trx)? If that is what it is, then Sortable Aggr() thing won't work, because it can work with fields but not with the expressions (Sum(Trx))

[phaneendra_kunc]

Yes Sunny. It is almost like Order By instead of Group by. Do we have any other option to compute this running total as dimension?

[sunny_talwar]

I will continue to look for options, but I am not very optimistic about it. May be someone else can offer a solution.

[phaneendra_kunc]

Thanks Sunny. Lets see if anyone else other ideas.

[phaneendra_kunc]

Any thoughts swuehl?

[#8]

Hi

use calculated dimension,

May its possible