topic Re: Advanced data grouping in App Development https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545419#M62804 <P>If you could add some sample input and how your output should look like , it will be easier to help . Please elaborate a bit as your question is bit unclear.</P> Sat, 16 Feb 2019 13:30:16 GMT pradosh_thakur 2019-02-16T13:30:16Z Advanced data grouping https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545357#M62803 <P>Hi,</P><P>I hope your help!!!...</P><P>I want to select a date, and then calculate sum(Cantidad_Saldo), if (sum(Cantidad_Saldo)&lt;&gt;0, Only show&nbsp; records of the last date, nothing to show)....&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 580px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/6167iD858B28433A95BBA/image-size/large?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P> Mon, 20 Dec 2021 21:38:40 GMT https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545357#M62803 olguita2014 2021-12-20T21:38:40Z Re: Advanced data grouping https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545419#M62804 <P>If you could add some sample input and how your output should look like , it will be easier to help . Please elaborate a bit as your question is bit unclear.</P> Sat, 16 Feb 2019 13:30:16 GMT https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545419#M62804 pradosh_thakur 2019-02-16T13:30:16Z Re: Advanced data grouping https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545434#M62805 <UL><LI>I have this data:</LI></UL><TABLE><TBODY><TR><TD>Date</TD><TD>KARHORA</TD><TD>MVESUFIJO</TD><TD>VEHCHASIS</TD><TD>Cantidad_Saldo</TD></TR><TR><TD>5/4/2018 00:00</TD><TD>12:26:15</TD><TD>AA</TD><TD>JTMZF9EV1ED022040</TD><TD>1</TD></TR><TR><TD>31/7/2018 00:00</TD><TD>16:07:08</TD><TD>AA</TD><TD>JTMZF9EV1ED022040</TD><TD>-1</TD></TR><TR><TD>31/7/2018 00:00</TD><TD>21:47:49</TD><TD>AA</TD><TD>JTMZF9EV1ED022040</TD><TD>1</TD></TR><TR><TD>4/2/2019 00:00</TD><TD>16:49:15</TD><TD>AA</TD><TD>JTMZF9EV1ED022040</TD><TD>-1</TD></TR></TBODY></TABLE><UL><LI>I want to select a date, and it depends on that to make a calculation, example: <STRONG>31/7/2018</STRONG></LI></UL><P><STRONG>&nbsp;</STRONG></P><UL><LI>If I select the date <STRONG>31/7/2018</STRONG> then the result of the field <STRONG>Cantidad_Saldo</STRONG> must be the total sum of all the amounts less than or equal to the chosen date. Result: Sum(<STRONG>Cantidad_Saldo</STRONG>)=1.</LI></UL><P>&nbsp;</P><P>&nbsp;</P><UL><LI>If the result of Sum(<STRONG>Cantidad_Saldo</STRONG>)=1, then create new field with the following data: <STRONG>Con Saldo, </STRONG>if not the following data is: <STRONG>Sin Saldo</STRONG>.</LI></UL><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Date</P></TD><TD><P>KARHORA</P></TD><TD><P>MVESUFIJO</P></TD><TD><P>VEHCHASIS</P></TD><TD><P>Sum(<STRONG>Cantidad_Saldo</STRONG>)</P></TD><TD><P>Estado_Saldo</P></TD></TR><TR><TD><P><STRONG>31/7/2018 00:00</STRONG></P></TD><TD><P>21:47:49</P></TD><TD><P>AA</P></TD><TD><P>JTMZF9EV1ED022040</P></TD><TD><P>1</P></TD><TD><P>Con Saldo</P></TD></TR><TR><TD><P>5/4/2018</P></TD><TD><P>12:26:15</P></TD><TD><P>AA</P></TD><TD><P>JTMZF9EV1ED022040</P></TD><TD><P>1</P></TD><TD><P>Con Saldo</P></TD></TR><TR><TD><P>4/2/2019</P></TD><TD><P>16:49</P></TD><TD><P>AA</P></TD><TD><P>JTMZF9EV1ED022040</P></TD><TD><P>0</P></TD><TD><P>Sin Saldo</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Feb 2019 16:44:06 GMT https://community.qlik.com/t5/App-Development/Advanced-data-grouping/m-p/1545434#M62805 olguita2014 2019-02-16T16:44:06Z