topic Re: How to write the below expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-the-below-expression/m-p/1072041#M921382 <HTML><HEAD></HEAD><BODY><P>In general, use aggregation functions in expressions:</P><P><A href="https://community.qlik.com/qlik-blogpost/3779">Use Aggregation Functions!</A></P><P></P><P>Your SEP field needs to be aggregated, otherwise, an implicte ONLY() function will be applied. If there are more than one value for SEP within the aggregation scope,NULL will be returned from ONLY.</P><P></P><P>Can't tell which function you need here, maybe Avg(SEP)?</P></BODY></HTML> Wed, 04 May 2016 11:29:28 GMT swuehl 2016-05-04T11:29:28Z How to write the below expression https://community.qlik.com/t5/QlikView/How-to-write-the-below-expression/m-p/1072040#M921381 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>How to write the below expression:</P><P></P><P style="font-size: 13.3333px;">How can I write the below expression:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">=(SUM(Aggr( Sum(purchase_receipts), Product,[Product Code],[Product Supplier/Code],[Demand Planner],[Signal/Code] )) - SUM(Aggr( Sum(qty_blocked_qc), Product,[Product Code],[Product Supplier/Code],[Demand Planner],[Signal/Code] ))) * SEP</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">when select particular product then the total is coming but when selecting all product then the sum is having NULL.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><IMG alt="Capture12.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123540_Capture12.PNG" style="height: 198px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-below-expression/m-p/1072040#M921381 suvechha_b 2020-11-25T16:16:04Z Re: How to write the below expression https://community.qlik.com/t5/QlikView/How-to-write-the-below-expression/m-p/1072041#M921382 <HTML><HEAD></HEAD><BODY><P>In general, use aggregation functions in expressions:</P><P><A href="https://community.qlik.com/qlik-blogpost/3779">Use Aggregation Functions!</A></P><P></P><P>Your SEP field needs to be aggregated, otherwise, an implicte ONLY() function will be applied. If there are more than one value for SEP within the aggregation scope,NULL will be returned from ONLY.</P><P></P><P>Can't tell which function you need here, maybe Avg(SEP)?</P></BODY></HTML> Wed, 04 May 2016 11:29:28 GMT https://community.qlik.com/t5/QlikView/How-to-write-the-below-expression/m-p/1072041#M921382 swuehl 2016-05-04T11:29:28Z