# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Contributor

## Diagonal Calculations - Data and App

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?:

1 Solution

Accepted Solutions
MVP

Try this

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

2 Replies
MVP

Try this

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

Contributor
Author

Thanks Sunny! It works!