Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

Hello,

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

Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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
Author

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
Author

Any other ideas?