Cumulative Sum in Straight Table...

[#1]

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

[Anonymous]

check these:

Running total / cummulative

Running total/Cumulative in pivot Chart | Qlik Community

Re: cumulative Value while loading

[sunny_talwar]

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

[Peter_Cammaert]

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

[Kushal_Chawda]

just need small change in calculated dimension

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