Qlik Community

Ask a Question

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

View solution in original post

ofalana1674
Contributor
Contributor
Author

Thanks Sunny! It works!