2 Replies Latest reply: Sep 25, 2014 8:16 AM by Geert Geladé RSS

    create table with left join along with multiple dimension

    vikas mahajan

      I have table A and I want to load this in Qlikview with left join or any join


      Item_CodeDimension Set IDLot No_Posting DateEntry_TypeDoc_NumLocation_CodeInventory_Post_Grp_CodeDept_CodeDiv_Code


      and Table B


      Dimension Set IDDimension CodeDimension Value CodeDimension Value IDName
      32182ALOC130369R&D Rabale
      32182DEPT2320920R&D - FDF - AMD
      32182DIV1120233FDF - Common

      I want to update Dimensions in table A  Dept_Code and Div_code   where Dimension  Set ID is common key for this and

      base on where condition Dimesion code= 'DIV'  I want to update div and dept while loading in Qlikview.


      I have attached excel sheet also , Urgent help required.