Diagonal Calculations - Data and App

ofalana1674 — Mon, 09 Jul 2018 18:15:31 GMT

Hi All: ( I am re-posting this to include Data and App)

I am not sure if this is possible but I am trying to determine the roll of customers with certain balances from month to month. For example, I want to know the percentage of customers with balances over $5000 in Month 1, whose balance dropped to between $2500 to $4999 in Month 2 . So in the example below (follow beige highlights), 2,000 customers had balances above $5000 in Month 1, out of these 2000, about 1,500 had reduced their balance to between $2500 to $4999 by Month 2 etc. The second table just shows this roll in percentage terms . Is there a way I can replicate the second table (percentages) in a Qlikview Pivot Table?:

Re: Diagonal Calculations - Data and App

sunny_talwar — Mon, 09 Jul 2018 19:06:18 GMT

Try this

=Sum(CustomerCount)/Before(Above(Sum(CustomerCount)))

Re: Diagonal Calculations - Data and App

ofalana1674 — Mon, 09 Jul 2018 19:24:22 GMT

Thanks Sunny! It works!

topic Re: Diagonal Calculations - Data and App in QlikView

Diagonal Calculations - Data and App

Re: Diagonal Calculations - Data and App

Re: Diagonal Calculations - Data and App