Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ofalana1674
Contributor
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?:

Capture.JPG

1 Solution

Accepted Solutions
sunny_talwar

Try this

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


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try this

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


Capture.PNG

ofalana1674
Contributor
Contributor
Author

Thanks Sunny! It works!