topic Cumulative Sum in Straight Table... in QlikView

Cumulative Sum in Straight Table...

Tue, 05 Jan 2016 13:00:28 GMT

Dear QV Experts,

I have a straight table filter based on the Top N Selections.

If Year, 2015 selected, Till Top 5 i can able to display five rows in a straight Table.

But when i want to view Top 6, i cant able to display six rows whereas when i select Top7, i can able to display seven rows.

Really Surprising.

Can you please suggest me on this.

Appreciate your prompt response.

Both the qvw, spreadsheet enclosed.

Regards,

SasiR

Re: Cumulative Sum in Straight Table...

Anonymous — Tue, 05 Jan 2016 13:15:03 GMT

check these:

Running total / cummulative

Running total/Cumulative in pivot Chart | Qlik Community

Re: cumulative Value while loading

Re: Cumulative Sum in Straight Table...

sunny_talwar — Tue, 05 Jan 2016 13:30:46 GMT

New improvised Calculated Dimension:

=If(Aggr(Rank(RangeSum(Sum(Sales),

Sum({<Year = {$(=Year-1)}>}Sales)/10000,

Sum({<Year = {$(=Year-2)}>}Sales)/100000,

Sum({<CustomerName = e(CustomerName), Year>} 0))) <= vTopX, CustomerName), CustomerName)

Since EFG and FGH were both 0s for 2015, it was assigning same ranks to both of them. I am not sure what you criteria is, but I used 2014 and 2013 numbers to assign rank when 2015 have same number. 2014 took a higher priority (divided by a smaller number 10,000) and 2013 took a lower priority (divided by a larger number 100,000)

HTH

Best,

Sunny

Re: Cumulative Sum in Straight Table...

Peter_Cammaert — Tue, 05 Jan 2016 13:37:48 GMT

...and ranks for same results assume the highest rank which is 7 when you select Top7. This is what your Calculated Dimension produces to select CustomerNames. Quite different from the other Rank expression.

Re: Cumulative Sum in Straight Table...

Kushal_Chawda — Tue, 05 Jan 2016 13:56:37 GMT

just need small change in calculated dimension

=If(Aggr(Rank(RangeSum(Sum(Sales), Sum({<CustomerName = e(CustomerName), Year>} 0)),4) <= vTopX, CustomerName), CustomerName)