topic Re: Excluding connected values in QlikView

Excluding connected values

Wed, 10 Jul 2013 09:45:56 GMT

Hi,

I'm trying to find a solution.

I have two fields:

Employee and Department.

Each employee has a linked department, even if he is a chief of this department. I also have a list of chiefs, stored into Excel file.

What I need is to load Employees, which are Chiefs without related field value in the field Department

Thanks for your help in advance!

Regards,

Kristina

Re: Excluding connected values

Wed, 10 Jul 2013 09:53:11 GMT

Hello Kristina,

i think about script functions like WHERE EXISTS or KEEP to reach your goal.

Are you able to upload some sample data?

Rainer

Re: Excluding connected values

swuehl — Wed, 10 Jul 2013 09:53:14 GMT

I am unsure what you are trying to achieve, maybe seomthing like this:

LOAD

Chief

FROM ExcelFile;

LOAD

Employee,

if(not exists(Chief, Employee), Department) as Department

FROM EmployeeTable;

Re: Excluding connected values

Wed, 10 Jul 2013 11:02:29 GMT

Hi swuehl!

Thanks for reply!

Exists is right what I need. But my QV Report is huge and I have to store information in different tables, using QUALIFY. So do I need to use resident [Chiefs] and how can I combine loading from 2 different sources

(only information about chiefs is from EXCEL, other fields are from SQL Server)?

Regards,

Kristina

Re: Excluding connected values

swuehl — Wed, 10 Jul 2013 12:09:29 GMT

Sorry Kristina,

I don't really get what your issue is here.

If you have already loaded the Chief field in another table, no need to reload it again. Exists wills check for value existence in fields, not in tables.

And combining multiple sources should be straight forward, just adapt your source in the LOAD statement.