Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Calendar Overview (Pivot)

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!

5 Replies
jagannalla
Valued Contributor III

Re: Calendar Overview (Pivot)

Hello,

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

Not applicable

Calendar Overview (Pivot)

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.

jagannalla
Valued Contributor III

Re: Calendar Overview (Pivot)

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.

Not applicable

Calendar Overview (Pivot)

The Datamodel is very simple, its like this:

TaskEmployeeStartDateEndDate
1A01.07.201201.07.2012
2A01.08.201202.08.2012
3A02.08.201202.08.2012
4B01.05.201205.05.2012
5B02.05.201202.05.2012
6C03.05.201203.05.2012
7C04.05.201204.05.2012
Not applicable

Calendar Overview (Pivot)

Any other ideas?

Community Browser