topic Re: Solution needed for below query please. in QlikView

Solution needed for below query please.

rahulhv1 — Wed, 19 Mar 2014 05:06:01 GMT

I have Three tables i.e .

1.Employee Master with fields : EmpCode., Name , Dept. Machineno,

2.Department Master with fields : Dept, MachienNO

3.Attendance Records with fields : EmpCode, Date

Result expected as under

Re: Solution needed for below query please.

sundarakumar — Wed, 19 Mar 2014 05:36:45 GMT

But as of data u have emp code d with name def for mc4 under production 1...

Y do u want to show No employee Present in this scenario?

Pls explain..

-Sundar

Re: Solution needed for below query please.

sundarakumar — Wed, 19 Mar 2014 05:37:30 GMT

Please explain the req, how do u want to show the data?

-Sundar

Re: Solution needed for below query please.

jagan — Wed, 19 Mar 2014 05:51:56 GMT

Hi Rahul,

Just load Employee Master and Attendance Record tables, both tables should join by EmpCode. That's it, now in chart

Dimension:

Department

MachineNo

Date

Expression:

Only(Employee) if for one machine there are multiple employees then use this

Concat(DISTINCT Employee)

Hope this helps you.

Regards,

Jagan.

Re: Solution needed for below query please.

its_anandrjs — Wed, 19 Mar 2014 06:09:56 GMT

Hi,

Write some thing below

load * Inline

[

empcode, Name, Department, MachineNo

a, abc, Production1, mc1

b, bcd, Production1, mc2

c, cde, Production1, mc3

d, def, Production1, mc4

e, efg, Production2, mc5

f, fgh, Production2, mc6

g, ghi, Production3, mc7

];

Left Join

AttendanceRecord:

load * Inline

[

empcode, Date

a, 01-Jan-14

b, 01-Jan-14

c, 01-Jan-14

d, 02-Jan-14

a, 02-Jan-14

b, 02-Jan-14

c, 02-Jan-14

d, 03-Jan-14

e, 03-Jan-14

];

Left Join

DepartmentMaster:

LOAD * Inline

[

Department., MachineNo

Production1,mc1

Production1,mc2

Production1,mc3

Production1,mc4

Production2,mc5

Production2,mc6

Production3,mc7

];

And in Dimension

Department

MachineNo

Date

in Expression empcode

Hope this helps

Thanks & Regards

Re: Solution needed for below query please.

SunilChauhan — Wed, 19 Mar 2014 07:07:03 GMT

see the attched file

hope this helps

Re: Solution needed for below query please.

rahulhv1 — Wed, 19 Mar 2014 09:43:46 GMT

Pls. see the output requird is as under

Selection : Dept : Production1 and data : 01Jan2014.

Output should be as under.

Dept Machine No. Date Empolyee

Production1 mc1 01Jan14 a

Production1 mc2 01Jan14 b

Production1 mc3 01Jan14 c

Production1 mc4 01Jan14 No Eployee Present on the date.

The about output shows that on 01Jan2014 Machineno. MC4 was idle as the empolyee was absent on that date.

Re: Solution needed for below query please.

SunilChauhan — Wed, 19 Mar 2014 09:46:47 GMT

Have you tried my post above