topic Calendar Overview (Pivot) in QlikView

Calendar Overview (Pivot)

Thu, 10 May 2012 08:33:02 GMT

Hello,

is it possible to display Appointments from different Employees in a Pivot like you can see in the attached .png file?

If i concatenate the tasks in one cell, i got a fine solution, but i need a cell for each task. It is important, that each week/day/date is shown only one time in the pivot table.

Any solutions here?

Thank you!

Re: Calendar Overview (Pivot)

jagannalla — Thu, 10 May 2012 09:16:25 GMT

Hello,

Hope it helps you. Can you see the attached file.

Calendar Overview (Pivot)

Thu, 10 May 2012 09:22:32 GMT

Hello,

in your example each employee(1-3) is a dimension.

But i dont know how many Employees i want to display, i got only 1 dimension which contain all employees.

Re: Calendar Overview (Pivot)

jagannalla — Thu, 10 May 2012 09:30:16 GMT

So you have only one field which contains all the employee names. Say for example;

EmpField

Emp1

Emp2

Emp3

- Then what about the tasks? from which field you are getting the task?

Can you please show your datamodel.

Calendar Overview (Pivot)

Thu, 10 May 2012 09:40:46 GMT

The Datamodel is very simple, its like this:

Task	Employee	StartDate	EndDate
1	A	01.07.2012	01.07.2012
2	A	01.08.2012	02.08.2012
3	A	02.08.2012	02.08.2012
4	B	01.05.2012	05.05.2012
5	B	02.05.2012	02.05.2012
6	C	03.05.2012	03.05.2012
7	C	04.05.2012	04.05.2012

Calendar Overview (Pivot)

Fri, 11 May 2012 07:34:59 GMT

Any other ideas?