Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.?

10 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Then for this you dont require the Exists function. All you do is load the full data.

     Now when ever you are looking the sales data in any chart, it will show you only the list of sales person which are associated with sales data.

     Only when you put listbox you will see all the sales person id and name.

     Have a look at the attached example for more clarification.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!