Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

cumulative pecentage doesn't work

I have the following code to do the snapshot percentage and it worked.

(count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days]) ) /(count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF]) )

 

Now I want to do the cumulative percentage, I tried two sets of code. They didn't work.

 

=rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days]),0,RowNo(total) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF])),0,RowNo(total)))

 

=rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days])) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF]))))

 

 

Thanks for your help!

1 Reply
Highlighted
Partner
Partner

It seems that you had a missing parenthesis in the first expression. Try this:

rangesum(above((count({< [Adopted in 15 days] = {'Yes'} >} [Adopted in 15 days]) + count({< [Adopted over 15 days] = {'Yes'} >} [Adopted over 15 days])),0,RowNo(total) )) /RangeSum(above((count([RPA number]) - count({< [Pending for TF] = {'Yes'} >} [Pending for TF])),0,RowNo(total)))