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

    Fill blanks fields with linked table value

      Hello,

      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.

       

      Thankx