Discussion Board for collaboration on QlikView Scripting.
I tried couple of options , but not able to get desired output.
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.
Right Output should be like below:
Attached is sample application
Go to Solution.
I guess you need a better key which can differentiate between g, kg, & mm and there associated measured value