topic Chart Building in QlikView https://community.qlik.com/t5/QlikView/Chart-Building/m-p/896124#M1016470 <HTML><HEAD></HEAD><BODY><P>To follow on from my previous post I am having an issue with a culmative total line that is exceeding 100%</P><P></P><P></P><P><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">above</SPAN>(<SPAN style="color: #0000ff;">total</SPAN> <SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">ClearUpCommittedTime_IPTHO</SPAN>=-{0}&gt;}ActualIncidents), 1, rowno(Total)))<BR /><BR />/<BR /><BR />sum({&lt;ClearUpCommittedTime_IPTHO=-{0}&gt;}total ActualIncidents) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">This is the existing formula in place which I didn't write, Is there an easier way of writing this?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The <SPAN style="color: #ff0000;">ClearUpCommittedTime_IPTHO</SPAN> is a integer field with seconds of time so 2 Minutes is showing as 120.</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #ff0000;">ActualIncidents</SPAN> is 1 or 0</SPAN></P></BODY></HTML> Fri, 10 Apr 2015 16:19:31 GMT cupelix-qlik 2015-04-10T16:19:31Z Chart Building https://community.qlik.com/t5/QlikView/Chart-Building/m-p/896124#M1016470 <HTML><HEAD></HEAD><BODY><P>To follow on from my previous post I am having an issue with a culmative total line that is exceeding 100%</P><P></P><P></P><P><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;">above</SPAN>(<SPAN style="color: #0000ff;">total</SPAN> <SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">ClearUpCommittedTime_IPTHO</SPAN>=-{0}&gt;}ActualIncidents), 1, rowno(Total)))<BR /><BR />/<BR /><BR />sum({&lt;ClearUpCommittedTime_IPTHO=-{0}&gt;}total ActualIncidents) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">This is the existing formula in place which I didn't write, Is there an easier way of writing this?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The <SPAN style="color: #ff0000;">ClearUpCommittedTime_IPTHO</SPAN> is a integer field with seconds of time so 2 Minutes is showing as 120.</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #ff0000;">ActualIncidents</SPAN> is 1 or 0</SPAN></P></BODY></HTML> Fri, 10 Apr 2015 16:19:31 GMT https://community.qlik.com/t5/QlikView/Chart-Building/m-p/896124#M1016470 cupelix-qlik 2015-04-10T16:19:31Z Re: Chart Building https://community.qlik.com/t5/QlikView/Chart-Building/m-p/896125#M1016471 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RangeSum(Above(SUM({&lt;<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #800000;">ClearUpCommittedTime_IPTHO</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;">=-{0}</SPAN>&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 16px;">ActualIncidents),0,RowNo()))</SPAN></SPAN></P><P><SPAN style="font-size: 12pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">/<BR />sum(TOTAL {&lt;ClearUpCommittedTime_IPTHO=-{0}&gt;}ActualIncidents)</SPAN></P></BODY></HTML> Fri, 10 Apr 2015 17:20:04 GMT https://community.qlik.com/t5/QlikView/Chart-Building/m-p/896125#M1016471 MK_QSL 2015-04-10T17:20:04Z