topic Re: Intersection of two dimensions in QlikView

Intersection of two dimensions

ilyas_coban — Fri, 07 Nov 2014 09:29:51 GMT

Hi all,

I have data like this:

XXX.ID	XXX.Start	XXX.End
1	01/01/2000 01:25	01/01/2000 02:25
2	01/01/2000 00:12	01/01/2000 01:12
3	01/01/2000 12:34	01/01/2000 14:34
4	01/01/2000 04:00	01/01/2000 05:00

YYY.ID	YYY.Start	YYY.End
5	01/01/2000 06:43	01/01/2000 09:25
6	01/01/2000 03:33	01/01/2000 09:25
3	01/01/2000 18:34	01/01/2000 19:34
4	01/01/2000 13:00	01/01/2000 15:30
4	02/01/2000 13:00	02/01/2000 15:30

...

And i want to calculate total work hours of person that works at both XXX and YYY departments for each day separately. YYY.ID and XXX.ID are not connected. Is there any way to do this without changing script? Like using calculated dimension or set analysis. I think an intersection like function can solve my problem but i couldn't find anything.

My result should look like this:

ID/Date	01/01/2000	02/01/2000
3	03:00	-
4	03:30	02:30

Best regards,

İlyas

Re: Intersection of two dimensions

alexandros17 — Fri, 07 Nov 2014 09:36:45 GMT

In dimension write If(XXX.Id=YYY.Id, XXX.Id, null())

then suppress Exclude null values checkbox.

In the expression simply sum your values from both tables: sum(valTable1)+sum(ValTable2)

where val ... are your hours

Re: Intersection of two dimensions

sujeetsingh — Fri, 07 Nov 2014 09:39:41 GMT

Ales is right you can use this as calculated diemsion.

Re: Intersection of two dimensions

ilyas_coban — Fri, 07 Nov 2014 12:48:34 GMT

Thanks.