topic How to group dimensions in the script in QlikView

topic How to group dimensions in the script in QlikView https://community.qlik.com/t5/QlikView/How-to-group-dimensions-in-the-script/m-p/801216#M661481 <HTML><HEAD></HEAD><BODY><P class="MsoNormal" style="margin: 0in 0in 0pt;"><A name="_MailAutoSig"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">My data has a row for each product.<SPAN style="mso-spacerun: yes;">  </SPAN>Each product has a “Type” category (i.e. “Old Product”, “New Product”).<SPAN style="mso-spacerun: yes;">  </SPAN>Multiple products can belong to one order.<SPAN style="mso-spacerun: yes;">  </SPAN>I am trying to assign “Type” at the order level, with the logic being if the Order has at least one product that is in the “New Product” category, call that entire order “New Product”.<SPAN style="mso-spacerun: yes;">  </SPAN>Is there a way to do this in the script?</SPAN></A></P><P class="MsoNormal"></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"> Thanks!</P><P><BR /> </P></BODY></HTML> Thu, 26 Mar 2015 16:28:39 GMT 2015-03-26T16:28:39Z How to group dimensions in the script https://community.qlik.com/t5/QlikView/How-to-group-dimensions-in-the-script/m-p/801216#M661481 <HTML><HEAD></HEAD><BODY><P class="MsoNormal" style="margin: 0in 0in 0pt;"><A name="_MailAutoSig"><SPAN style="font-family: Calibri; color: #000000; font-size: 12pt;">My data has a row for each product.<SPAN style="mso-spacerun: yes;">  </SPAN>Each product has a “Type” category (i.e. “Old Product”, “New Product”).<SPAN style="mso-spacerun: yes;">  </SPAN>Multiple products can belong to one order.<SPAN style="mso-spacerun: yes;">  </SPAN>I am trying to assign “Type” at the order level, with the logic being if the Order has at least one product that is in the “New Product” category, call that entire order “New Product”.<SPAN style="mso-spacerun: yes;">  </SPAN>Is there a way to do this in the script?</SPAN></A></P><P class="MsoNormal"></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"> Thanks!</P><P><BR /> </P></BODY></HTML> Thu, 26 Mar 2015 16:28:39 GMT https://community.qlik.com/t5/QlikView/How-to-group-dimensions-in-the-script/m-p/801216#M661481 2015-03-26T16:28:39Z