4 Replies Latest reply: Mar 2, 2016 3:44 AM by Teoman Tamer RSS

    How to combine several rows to one row

    Teoman Tamer

      Hello,

       

      I have the following issue.

       

      I anaylse values with I get direct from an database with many many tables in it.

       

      So I am loding the required values into qlikview.

       

      Now I am using Table-Diagram to make combine / visualise the values.

       

      For the item characteristic values I have to use an WildMatch.

       

      =if(WildMatch(FEATURE1,'WST*'),ItemDescription) --> Material

      =if(WildMatch(FEATURE1,'BAB*'),ItemDescription) --> Thickness

      =if(WildMatch(FEATURE1,'BAL*'),ItemDescription) --> Length

       

      Item#    /   Stock   /  Last change   /  Material   / thickness  / length

      a               2          01/03/2016          1,4571          -               -

      a               2          01/03/2016               -               1               -

      a               2          01/03/2016               -               -               20

       

      I need the values in one row.

       

      Item#    /   Stock   /  Last change   /  Material   / thickness  / length

      a               2          01/03/2016          1,4571        1               20

       

      The item properties are in separate tables.

       

      The KEY is the Item#--> with the item number I get the Item properity codes (FEATURE1) like WST (Material), BAB (Thickness), ...

       

      and over the properity code I get the required value for the material.

       

      How I can combine the values in one row?

       

      Thank you in advance