Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Diagonal Calculations - Data and App

Try this

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


Capture.PNG

View solution in original post

2 Replies

Re: Diagonal Calculations - Data and App

Try this

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


Capture.PNG

View solution in original post

ofalana1674
New Contributor

Re: Diagonal Calculations - Data and App

Thanks Sunny! It works!