topic Cumul inverse in QlikView

Cumul inverse

Mon, 25 Jan 2010 13:03:29 GMT

Hi all,

I can't figure out how to write the right expression to get a cumul inverse, that is to say a total sum minus cumulated numbers.

In my file, I've got customers who were billed from 0 to n months ("n" is still evolving). Thus there are X customers matching with 0 bill, Y with 1 bill ....Z with N bills .

I'd like to see graphically the following expression:

for month 0 = Total sum

for month 1 = Total sum - customers Month 0

for month 2 = Total sum - (customers Month 0 + customers month 1)

....

for month N = Total sum - (customers Month 0 +.... + customers Month N-1)

Thanks for your help

Julien

Cumul inverse

Mon, 25 Jan 2010 17:58:33 GMT

Hi Julien,

I hope I have understood your requirement correctly. You could use the following expression

=TextCount(Total Customer)-rangesum(above(TextCount(Customer),1,rowno()-1))

For convinience, I have attached an example as per my understanding of your data model.

Nimish

Cumul inverse

Fri, 29 Jan 2010 17:49:21 GMT

Hi Nimish,

Thank you for your answer. It works well.

I can go on further with this analysis.

Cheers,

Julien