topic Find latest status and sum value in QlikView https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308696#M617575 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>I have a table below, what i want is to get the updated status of of users and sum all those values and<SPAN style="color: #575757;"> <SPAN style="text-decoration: underline;">do it in function</SPAN></SPAN> , any suggestion ?</P><P></P><P></P><P></P><P>UserID&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/2/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/3/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/6/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/7/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/12/2017&nbsp;&nbsp;&nbsp; <SPAN style="color: #3366ff;"><STRONG>Status_B</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (So sum all Status_B for A)</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/1/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/2/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/12/2017&nbsp;&nbsp;&nbsp; Status_D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>The expected result</P><P></P><P>UserID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900&nbsp;&nbsp;&nbsp; (200+300+400)&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; </P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 09 May 2017 11:07:50 GMT Anonymous 2017-05-09T11:07:50Z Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308696#M617575 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>I have a table below, what i want is to get the updated status of of users and sum all those values and<SPAN style="color: #575757;"> <SPAN style="text-decoration: underline;">do it in function</SPAN></SPAN> , any suggestion ?</P><P></P><P></P><P></P><P>UserID&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/2/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/3/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/6/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/7/2017&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/12/2017&nbsp;&nbsp;&nbsp; <SPAN style="color: #3366ff;"><STRONG>Status_B</STRONG></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (So sum all Status_B for A)</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/1/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/2/2017&nbsp;&nbsp;&nbsp;&nbsp; Status_C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/12/2017&nbsp;&nbsp;&nbsp; Status_D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>The expected result</P><P></P><P>UserID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 900&nbsp;&nbsp;&nbsp; (200+300+400)&nbsp;&nbsp; </P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status_D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp; </P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 09 May 2017 11:07:50 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308696#M617575 Anonymous 2017-05-09T11:07:50Z Re: Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308697#M617576 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P>Dimension</P><P><STRONG>UserID</STRONG></P><P></P><P>Expression</P><P><STRONG>FirstSortedValue( Status, - Date)</STRONG></P><P><STRONG>Sum(Aggr(If(Status = FirstSortedValue(TOTAL &lt;UserID&gt; Status, - Date), Value), UserID, Status, Date))</STRONG></P></BODY></HTML> Tue, 09 May 2017 12:15:53 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308697#M617576 sunny_talwar 2017-05-09T12:15:53Z Re: Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308698#M617577 <HTML><HEAD></HEAD><BODY><P>thank you for your help, but it seems not working, it give me 0.</P></BODY></HTML> Tue, 09 May 2017 12:24:41 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308698#M617577 Anonymous 2017-05-09T12:24:41Z Re: Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308699#M617578 <HTML><HEAD></HEAD><BODY><P>thank you for your help, but it seems not working, it give me 0.</P><P></P><P>I want to show it in bar chart actually,</P><P></P><P>so that the the chart show below</P><P></P><P></P><P>Status B&nbsp;&nbsp;&nbsp;&nbsp; Status D</P></BODY></HTML> Tue, 09 May 2017 12:27:02 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308699#M617578 Anonymous 2017-05-09T12:27:02Z Re: Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308700#M617579 <HTML><HEAD></HEAD><BODY><P>Not sure I understand... what is your bar chart dimension? Status?</P></BODY></HTML> Tue, 09 May 2017 15:27:01 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308700#M617579 sunny_talwar 2017-05-09T15:27:01Z Re: Find latest status and sum value https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308701#M617580 <HTML><HEAD></HEAD><BODY><P>imy mistake, it works, thxSunny </P></BODY></HTML> Wed, 10 May 2017 02:06:25 GMT https://community.qlik.com/t5/QlikView/Find-latest-status-and-sum-value/m-p/1308701#M617580 Anonymous 2017-05-10T02:06:25Z