0 Replies Latest reply: Apr 16, 2013 5:11 AM by marc_raphael RSS

    Fill blanks fields with linked table value


      I'm new in qlikview and I wanted to kno if someone can help me in finding the solution of:


      I got 3 linked tables 1, 2 ,3 from 3 excel files.

      The second table has a field called PN with blanks values and the way to get values is to use CNN field and get the same line PN value in the table 3.



      Table 2                                    Table 3                                                  Table 2


      PN with blanks

      CNN >>>>>>>>>>>>>>>>>>CNN>>PN (one or some) >>>>>>>>>>>PN (gathered separated by ";" if more than 1 PN)



      If some one knows how to do that, or what functions to use in the console window it would be nice.