Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cupelix-qlik
Contributor III
Contributor III

Chart Building

To follow on from my previous post I am having an issue with a culmative total line that is exceeding 100%

(above(total sum({<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents), 1, rowno(Total)))

/

sum({<ClearUpCommittedTime_IPTHO=-{0}>}total ActualIncidents)

This is the existing formula in place which I didn't write, Is there an easier way of writing this?

The ClearUpCommittedTime_IPTHO is a integer field with seconds of time so 2 Minutes is showing as 120.

ActualIncidents is 1 or 0

1 Reply
MK_QSL
MVP
MVP

RangeSum(Above(SUM({<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents),0,RowNo()))

/
sum(TOTAL {<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents)