# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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!