Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.?
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