10 Replies Latest reply: Mar 22, 2013 5:59 AM by Kaushik Solanki RSS

    How to populate referenced columns from a single table.

      Hi, I am new to QlikView, so not sure if this question is already addressed. There are 2 tables that is imported in QlikView. Each table has a field "Location".

      There is a table "Sales" , "Location Info".

      Now the problem is when I try to get values of "Location" corresponding to a single table "Sales" . I get the values of "Location" present in Location table as well.

       

      Can we restrict the "Location" value from a single table, maintaing the relation between table. So that I can see "Location desc" etc, from the other table when I select a "Location" from Sales table.?