Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Marie201931
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
fosuzuki
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)))