topic Script Help !!! in QlikView https://community.qlik.com/t5/QlikView/Script-Help/m-p/1121424#M629326 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I tried couple of options , but not able to get desired output.</P><P></P><P>See below table : Actual Value is "2188.00" against Unit_Short "g" , but not sure why this value is repeating for kg and mm also.</P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/136126_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Right Output should be like below:</P><P></P><P><IMG alt="" class="jive-image image-4" src="https://community.qlik.com/legacyfs/online/136127_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Please help!</P><P></P><P>Attached is sample application</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Wed, 31 Aug 2016 10:45:01 GMT amit_saini 2016-08-31T10:45:01Z Script Help !!! https://community.qlik.com/t5/QlikView/Script-Help/m-p/1121424#M629326 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I tried couple of options , but not able to get desired output.</P><P></P><P>See below table : Actual Value is "2188.00" against Unit_Short "g" , but not sure why this value is repeating for kg and mm also.</P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/136126_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Right Output should be like below:</P><P></P><P><IMG alt="" class="jive-image image-4" src="https://community.qlik.com/legacyfs/online/136127_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Please help!</P><P></P><P>Attached is sample application</P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Wed, 31 Aug 2016 10:45:01 GMT https://community.qlik.com/t5/QlikView/Script-Help/m-p/1121424#M629326 amit_saini 2016-08-31T10:45:01Z Re: Script Help !!! https://community.qlik.com/t5/QlikView/Script-Help/m-p/1121425#M629328 <HTML><HEAD></HEAD><BODY><P>I guess you need a better key which can differentiate between g, kg, &amp; mm and there associated measured value</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136114_Capture.PNG" style="height: 68px; width: 620px;" /></P></BODY></HTML> Wed, 31 Aug 2016 10:51:22 GMT https://community.qlik.com/t5/QlikView/Script-Help/m-p/1121425#M629328 sunny_talwar 2016-08-31T10:51:22Z