https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080575#M231663 <P>Can you tell the business logic to create <SPAN>RESULT_QTY.</SPAN></P> Tue, 06 Jun 2023 11:41:17 GMT Gabbar 2023-06-06T11:41:17Z https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080352#M231625 <P>Hi experts,</P> <P>I used following formula to calculate Remaining Qty for orders. This has values both minus and plus. Now I need to calculate how many minus values per order. How to do such? Please forward your Ideas&nbsp;</P> <P>($(wip1)+$(wip2)+$(RM_Stock)+ $(IN_Tran_WIP)-(sum(<BR />aggr( nodistinct<BR />rangesum(<BR />above(<BR />total sum({1}QTY_REQUIRED),0,RowNo()<BR />)<BR />)<BR />,RPART_NO ,(ORDER_NO,( LOAD_ORDER,ASCENDING))<BR />)<BR />)-QTY_REQUIRED) )- QTY_REQUIRED&nbsp;</P> Tue, 06 Jun 2023 01:24:12 GMT https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080352#M231625 layanmahendra 2023-06-06T01:24:12Z https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080395#M231632 <P>For Example You have a field , FieldA which you are calculating,<BR />now if you want only those where fieldA is negative you can add:<BR />fieldA={"&lt;0"}&nbsp;<BR />in the set expression.</P> Tue, 06 Jun 2023 06:07:56 GMT https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080395#M231632 Gabbar 2023-06-06T06:07:56Z https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080536#M231654 <P>RPART&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; QTY&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PRIORITY_CAT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YEAR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RESULT_QTY</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &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; &nbsp;&nbsp;2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 38&nbsp; &nbsp;&nbsp;</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;33&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2023&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;43</P> <P>&nbsp;</P> <P>Data has sorted to Priority_category and Year already. Output like be this. I need load script to get this RESULT_QTY</P> Tue, 06 Jun 2023 10:03:09 GMT https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080536#M231654 layanmahendra 2023-06-06T10:03:09Z https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080575#M231663 <P>Can you tell the business logic to create <SPAN>RESULT_QTY.</SPAN></P> Tue, 06 Jun 2023 11:41:17 GMT https://community.qlik.com/t5/Visualization-and-Usability/Aggr-and-count/m-p/2080575#M231663 Gabbar 2023-06-06T11:41:17Z