topic Re: Running Total as a Dimension in QlikView

Running Total as a Dimension

phaneendra_kunc — Fri, 05 Aug 2016 19:08:10 GMT

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

Re: Running Total as a Dimension

sunny_talwar — Fri, 05 Aug 2016 19:17:05 GMT

What is the sort order you are looking for Phani?

Re: Running Total as a Dimension

sunny_talwar — Fri, 05 Aug 2016 19:20:03 GMT

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))

Re: Running Total as a Dimension

phaneendra_kunc — Fri, 05 Aug 2016 19:26:27 GMT

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?

Re: Running Total as a Dimension

sunny_talwar — Fri, 05 Aug 2016 19:31:20 GMT

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

Re: Running Total as a Dimension

phaneendra_kunc — Fri, 05 Aug 2016 19:42:33 GMT

Thanks Sunny. Lets see if anyone else other ideas.

Re: Running Total as a Dimension

phaneendra_kunc — Fri, 05 Aug 2016 21:17:27 GMT

Any thoughts swuehl?

Re: Running Total as a Dimension

Sat, 06 Aug 2016 02:15:50 GMT

use calculated dimension,

May its possible