https://community.qlik.com/t5/QlikView/aggregate-values-by-field/m-p/1694399#M725941 <P>Hi,&nbsp;</P><P>I can't seem to figure out how I can Aggregate values for all values within one field that are the same. In my example I have customer IDs and Membership start and end Dates. I would like to calculate the Membership Duration per customer ID.&nbsp;</P><P>Customer ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Membership Duration &nbsp; &nbsp; &nbsp; expected result: Duration.per member</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 364 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 864 days</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 864 days</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 864 days &nbsp;</P><P>5656 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70 days</P><P>5656 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70 days&nbsp;</P><P>&nbsp;</P><P>Now I would like to create a new field which sums up all values for the same customer ID, meaning 864 days for customer 5555 and 70 days for customer 5656 and so on.&nbsp;</P><P>Can I do this as a Chart function instead of in the script?&nbsp;</P><P>I would appreciate any help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT nina_le_06 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/aggregate-values-by-field/m-p/1694399#M725941 <P>Hi,&nbsp;</P><P>I can't seem to figure out how I can Aggregate values for all values within one field that are the same. In my example I have customer IDs and Membership start and end Dates. I would like to calculate the Membership Duration per customer ID.&nbsp;</P><P>Customer ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Membership Duration &nbsp; &nbsp; &nbsp; expected result: Duration.per member</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 364 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 864 days</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 864 days</P><P>5555 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 864 days &nbsp;</P><P>5656 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70 days</P><P>5656 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40 days &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70 days&nbsp;</P><P>&nbsp;</P><P>Now I would like to create a new field which sums up all values for the same customer ID, meaning 864 days for customer 5555 and 70 days for customer 5656 and so on.&nbsp;</P><P>Can I do this as a Chart function instead of in the script?&nbsp;</P><P>I would appreciate any help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/aggregate-values-by-field/m-p/1694399#M725941 nina_le_06 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/aggregate-values-by-field/m-p/1694403#M725942 <P>Try this expression:</P><P>sum(total &lt;[Customer ID]&gt;[Membership Duration])</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Vegar_0-1587121951349.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32025iAB764517FB744AE6/image-size/medium?v=v2&amp;px=400" role="button" title="Vegar_0-1587121951349.png" alt="Vegar_0-1587121951349.png" /></span></P><P>&nbsp;</P><P>See attached qvw</P> Fri, 17 Apr 2020 11:12:55 GMT https://community.qlik.com/t5/QlikView/aggregate-values-by-field/m-p/1694403#M725942 Vegar 2020-04-17T11:12:55Z