Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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)))