topic Merge cells in QlikView

Merge cells

Fri, 03 Feb 2012 12:56:36 GMT

I everyone, I use a pivot table which shows planned hours on projects. Resources spend hours on the projects.

For example; this is how it shows now:

Now it looks like there are 172 hours planned on this projects for both resources someone1 and someone2.

I would like it to look like this (this is Excel):

How do I achieve something like this so it shows the planned hours of 172 for this project not per resource?

Thanks

jjfabian — Fri, 03 Feb 2012 12:59:24 GMT

If you use your planned hours as a dimension, you should be able to pivotize it. Use a pivot table instead of a straight table.

Fri, 03 Feb 2012 13:06:21 GMT

hmm..i think you still using straight table not pivot table.

Fri, 03 Feb 2012 13:09:25 GMT

Thanks , I have it now