topic Re: Manipulation of script fields in QlikView https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441052#M432391 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Basically I'm busy with sales trending. </P><P></P><P>The 3 lines populated for the same document is my 3 trending codes.</P><P>I used my packsize trending code to calculate the invoiced units field.</P><P></P><P>But ultimately I want the units sold result next to each trending code (MFGTYPE and SERVICE)</P><P></P><P>Currently what I want to achieve in my object is to sum the invoiced units, if MFGTYPE is equal to MP, HP or SHP.</P><P></P><P>This will then compare the units sold of machine packed, hand packed and semi-hand packed.</P></BODY></HTML> Thu, 26 Oct 2017 12:28:50 GMT ranibosch 2017-10-26T12:28:50Z Manipulation of script fields https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441050#M432389 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/4003">hic</A>‌ </P><P>Good day,</P><P></P><P>My data pulls as follows with my current script:</P><P></P><P><IMG __jive_id="181033" alt="Script issue.JPG" class="jive-image image-1" src="/legacyfs/online/181033_Script issue.JPG" style="height: 122px; width: 620px;" /></P><P></P><P>Would it be possible to amend to look like the bottom table?</P></BODY></HTML> Thu, 26 Oct 2017 12:01:13 GMT https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441050#M432389 ranibosch 2017-10-26T12:01:13Z Re: Manipulation of script fields https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441051#M432390 <HTML><HEAD></HEAD><BODY><P>How did you choose MFGTYPE out of the three among Trending Code? Also, is this something you need from script?</P></BODY></HTML> Thu, 26 Oct 2017 12:13:07 GMT https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441051#M432390 sunny_talwar 2017-10-26T12:13:07Z Re: Manipulation of script fields https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441052#M432391 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Basically I'm busy with sales trending. </P><P></P><P>The 3 lines populated for the same document is my 3 trending codes.</P><P>I used my packsize trending code to calculate the invoiced units field.</P><P></P><P>But ultimately I want the units sold result next to each trending code (MFGTYPE and SERVICE)</P><P></P><P>Currently what I want to achieve in my object is to sum the invoiced units, if MFGTYPE is equal to MP, HP or SHP.</P><P></P><P>This will then compare the units sold of machine packed, hand packed and semi-hand packed.</P></BODY></HTML> Thu, 26 Oct 2017 12:28:50 GMT https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441052#M432391 ranibosch 2017-10-26T12:28:50Z Re: Manipulation of script fields https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441053#M432392 <HTML><HEAD></HEAD><BODY><P>Maybe?</P><P></P><P>=if([Trending Code]='MFGTYPE',sum(aggr(sum([Invoiced Units]),[Item No])))</P></BODY></HTML> Thu, 26 Oct 2017 17:09:16 GMT https://community.qlik.com/t5/QlikView/Manipulation-of-script-fields/m-p/1441053#M432392 Anonymous 2017-10-26T17:09:16Z