topic Re: Cumulative measure using dimension in App Development https://community.qlik.com/t5/App-Development/Cumulative-measure-using-dimension/m-p/1315494#M28229 <HTML><HEAD></HEAD><BODY><P>I solved myself adding a new table IN SQL</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169429_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 07 Jul 2017 10:15:18 GMT 2017-07-07T10:15:18Z Cumulative measure using dimension https://community.qlik.com/t5/App-Development/Cumulative-measure-using-dimension/m-p/1315493#M28228 <HTML><HEAD></HEAD><BODY><P>Hello from France</P><P>I ve got a nice question for you</P><P><STRONG style=": ; color: #808000; font-family: courier new,courier;"><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/168908_pastedImage_18.png" style="max-width: 1200px; max-height: 900px;" />DATE_Beg</STRONG> is my <STRONG>Dimension</STRONG></P><P>I want to have 2 <STRONG>Measures</STRONG> on my graph.</P><P>The First is OK : Cumulative of Beginnings</P><P style="padding-left: 30px;"><SPAN style="color: #808000; font-family: courier new,courier;">rangesum( above( COUNT([ID_RECORD]),0,rowno()))</SPAN></P><P>The Second False is easy to calculate but false:</P><P style="padding-left: 30px;"><SPAN style="color: #ff0000; font-family: courier new,courier;">rangesum( above( COUNT([DATE_End]),0,rowno()))</SPAN></P><P>In effect, For my graph, I want the Cumul of RECORD who have ended at the date of the Dimension. It would be something like that...</P><P style="padding-left: 30px;"><SPAN style="color: #ff0000; font-family: courier new,courier;">rangesum( above( COUNT( {&lt; DATE_End= {" &lt; MAX(DATE_Beg)"} &gt;}&nbsp; DATE_End)</SPAN></P><P></P><P></P><P>Do you have any idea of the way to calculate this second measure????</P><P></P><P>Thank you very much!!</P><P></P><P>Martin</P></BODY></HTML> Mon, 03 Jul 2017 15:25:41 GMT https://community.qlik.com/t5/App-Development/Cumulative-measure-using-dimension/m-p/1315493#M28228 2017-07-03T15:25:41Z Re: Cumulative measure using dimension https://community.qlik.com/t5/App-Development/Cumulative-measure-using-dimension/m-p/1315494#M28229 <HTML><HEAD></HEAD><BODY><P>I solved myself adding a new table IN SQL</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/169429_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 07 Jul 2017 10:15:18 GMT https://community.qlik.com/t5/App-Development/Cumulative-measure-using-dimension/m-p/1315494#M28229 2017-07-07T10:15:18Z