topic Re: how to get the rest of the employees details...?? in QlikView

how to get the rest of the employees details...??

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi All.

i have permanent employee details in table A and all contract employee details in table B.. and swipe in information for both of these and also visitors details are available in another table C..

Emp ID is the common key for all the tables. now how to get the 3rd category people like visitors.

Any pointers on How we can achieve this, Thanks in advance.

Re: how to get the rest of the employees details...??

Gysbert_Wassenaar — Sun, 01 Jul 2018 15:23:41 GMT

Concatenate all the records from tables A,B and C into one table and add a field that indicates what kind of record it is, e.g. 'permanent', 'contract', 'visitor'

Re: how to get the rest of the employees details...??

vishalgoud — Sun, 01 Jul 2018 19:57:11 GMT

thanks Much for the reply,

table A with permanent employee details.

table B with Contract employee details.

table C with all employee details along with visitors details.

So i want to substrct both table A and B from Table C so that will get the visitors information...is there any way to do that...??

i want the counts from table C which are not in table A and B...

Where not exists work for my above seanario !!

Re: how to get the rest of the employees details...??

BalaBhaskar_Qlik — Mon, 02 Jul 2018 03:04:07 GMT

May be:

Either Permanent / Contract Employee, they'll have one type of Employee Code. For Visitors it'll be allocated differently.

So compare based on EmployeeID, where it's null for Visitors. In Table A, Add a Flag to indicate Permanent, In Table B, Add a Flag to indicate Contract, in Table C create a condition to check permanent or contract, so the remaining people falls in Visitors category.

Re: how to get the rest of the employees details...??

jyothish8807 — Mon, 02 Jul 2018 06:09:31 GMT

Hi Vishal,

Try like this:

Load

Name

from permanent;

concatenate

Load

Name

from Contract ;

Join (A)

Load

Name,

Name as NewName

from Allemp_visitor;

Noconcatenate:

😧

Load

Name,

if(Name=NewName,1,0) as Flag

resident A;

Drop table A;

Visitor:

Load

Name as VisitorName

resident D

where Flag=0;

Br,

Re: how to get the rest of the employees details...??

jyothish8807 — Mon, 02 Jul 2018 06:15:03 GMT

You can replace name with your empID field.

Re: how to get the rest of the employees details...??

jyothish8807 — Mon, 02 Jul 2018 06:17:28 GMT

One other way:

Load

Empid

from permanent;

concatenate

Load

Empid

from Contract ;

Noconcatenate

Load

count(Empid) as Countvisitors,

from Allemp_visitor

where not exists (Empid,Empid);

Br,