16 Replies Latest reply: Dec 27, 2015 9:15 AM by Fateh FATEHCH RSS

    I cant load values with concatination function

      Hello all members

      I have a big probléme when i load data from my exel file.

      i have two columns code1 and code2 , i concatinate them in the exel   and i use the pivote table i found 14999 values ,but when i concatinated them in qlikview i found 14684 , i had 3 day to resolve this probléme and i cant resolve it

      My question , how i can load all values from the concatination code1 and code2  without dublicates values

       

      My file is attached coontaint the liste code and the pivote table .

      For the second is the qlikview file

       

      Thanks all