Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Graph Daily Incremental/Cumulative %

Hello,

 

Im trying to chart the percentage of timeliness cumulative by for the current month by day, I tried the formula below with no success.

 

=aggr(rangesum(above((sum([ddweeklytimeliness.AllAppTimely])/sum([ddweeklytimeliness.AllAppTotal]),0,rowno()))),[ddweeklytimeliness.dispdate])

Thank you.

4 Replies
Anil_Babu_Samineni

Check this

=Sum(aggr(rangesum(above((sum([ddweeklytimeliness.AllAppTimely])/sum([ddweeklytimeliness.AllAppTotal]),0,rowno(TOTAL)))),[ddweeklytimeliness.dispdate]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
danieldors
Contributor III
Contributor III
Author

Thank you for your response but it didn't work.

Anil_Babu_Samineni

Your title shows different than your context. so difficult to find. Can you explain little more?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
danieldors
Contributor III
Contributor III
Author

Im trying to show a graph, as follows. Nov 1t timeliness 98%, Nov 2 97%, Nov 3 99%, the data for Nov 3 would include Nov 1-3, not individual days.