QlikView, How to show weeks and YTD Month and YTD Year on columns

[Anonymous]

Hi everyone,

I'm trying to solve the following requirement. We need to create a table that shows some measures on rows and on columns shows the weeks for a selected month plus the cumulated value for that month plus the cumulated value for the whole year. Eg.

	Week1	Week2	Week3	Week 4	Month	Year
Actual
Budget
Act. / Bud.
Diff

My problem is that since I'm using expressions on rows I have to use a Dimension on columns, but as you can see there is a mix between levels (weeks, month, and year).

Any idea on how to solve this with a single table?

Many thanks in advanced.

Pepe

[Anonymous · Accepted solution]

have a look here: Enhanced Pivot Table

--> it is basically the same challenge.

[Anonymous]

Many thanks Robin,

as you mention It seems to be essentially the same. I'll give it a try.

[Daniel_G]

@Anonymous: Did you find a solution to do it? Can you may share an example app?