topic remove the Row with Zero Quantity in App Development https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419891#M95566 <P>Hi,</P> <P>&nbsp;</P> <P>i have data loaded in the qlik which is Table 1.</P> <P>so i want to remove the row which is zero in the Confirm Quantity.&nbsp;</P> <P>please suggest&nbsp;</P> <P>Tabel 1</P> <TABLE width="598"> <TBODY> <TR> <TD width="115">Order Number</TD> <TD width="167">Schedule Line Number</TD> <TD width="114">Material_Code</TD> <TD width="107">Material Name</TD> <TD width="95">Confirm Qty</TD> </TR> <TR> <TD>1234</TD> <TD>2</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>2</TD> </TR> <TR> <TD>1234</TD> <TD>1</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>0</TD> </TR> <TR> <TD>3456</TD> <TD>2</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>1</TD> </TR> <TR> <TD>3456</TD> <TD>1</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>0</TD> </TR> <TR> <TD>9805</TD> <TD>2</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>5</TD> </TR> <TR> <TD>9805</TD> <TD>1</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Final table like this&nbsp;</P> <TABLE width="598"> <TBODY> <TR> <TD width="115">Order Number</TD> <TD width="167">Schedule Line Number</TD> <TD width="114">Material_Code</TD> <TD width="107">Material Name</TD> <TD width="95">Confirm Qty</TD> </TR> <TR> <TD>1234</TD> <TD>2</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>2</TD> </TR> <TR> <TD>3456</TD> <TD>2</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>1</TD> </TR> <TR> <TD>9805</TD> <TD>2</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>5</TD> </TR> </TBODY> </TABLE> Fri, 16 Feb 2024 09:42:28 GMT suhascool1 2024-02-16T09:42:28Z remove the Row with Zero Quantity https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419891#M95566 <P>Hi,</P> <P>&nbsp;</P> <P>i have data loaded in the qlik which is Table 1.</P> <P>so i want to remove the row which is zero in the Confirm Quantity.&nbsp;</P> <P>please suggest&nbsp;</P> <P>Tabel 1</P> <TABLE width="598"> <TBODY> <TR> <TD width="115">Order Number</TD> <TD width="167">Schedule Line Number</TD> <TD width="114">Material_Code</TD> <TD width="107">Material Name</TD> <TD width="95">Confirm Qty</TD> </TR> <TR> <TD>1234</TD> <TD>2</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>2</TD> </TR> <TR> <TD>1234</TD> <TD>1</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>0</TD> </TR> <TR> <TD>3456</TD> <TD>2</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>1</TD> </TR> <TR> <TD>3456</TD> <TD>1</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>0</TD> </TR> <TR> <TD>9805</TD> <TD>2</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>5</TD> </TR> <TR> <TD>9805</TD> <TD>1</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Final table like this&nbsp;</P> <TABLE width="598"> <TBODY> <TR> <TD width="115">Order Number</TD> <TD width="167">Schedule Line Number</TD> <TD width="114">Material_Code</TD> <TD width="107">Material Name</TD> <TD width="95">Confirm Qty</TD> </TR> <TR> <TD>1234</TD> <TD>2</TD> <TD>10C39</TD> <TD>Wooden Box</TD> <TD>2</TD> </TR> <TR> <TD>3456</TD> <TD>2</TD> <TD>39C34</TD> <TD>Glass</TD> <TD>1</TD> </TR> <TR> <TD>9805</TD> <TD>2</TD> <TD>56C34</TD> <TD>Cotton</TD> <TD>5</TD> </TR> </TBODY> </TABLE> Fri, 16 Feb 2024 09:42:28 GMT https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419891#M95566 suhascool1 2024-02-16T09:42:28Z Re: remove the Row with Zero Quantity https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419896#M95567 <P>You can do this when loading data by adding the clause where<EM> Confirm Qty &lt;&gt; 0</EM>, or with a set analysis in a measure of your table<EM> {&lt;[Confirm Qty] -= {"0"}&gt;}</EM>.<BR /><BR />Kind regards,<BR />Théo ATRAGIE.</P> Fri, 16 Feb 2024 09:47:13 GMT https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419896#M95567 theoat 2024-02-16T09:47:13Z Re: remove the Row with Zero Quantity https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419921#M95571 <P>Thank you</P> Fri, 16 Feb 2024 10:18:37 GMT https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419921#M95571 suhascool1 2024-02-16T10:18:37Z Re: remove the Row with Zero Quantity https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419922#M95572 <P>You welcome,&nbsp;<BR />Have a nice day.</P> Fri, 16 Feb 2024 10:21:55 GMT https://community.qlik.com/t5/App-Development/remove-the-Row-with-Zero-Quantity/m-p/2419922#M95572 theoat 2024-02-16T10:21:55Z