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

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

Anonymous — Wed, 22 Mar 2017 17:56:43 GMT

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

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

Anonymous — Wed, 22 Mar 2017 18:03:45 GMT

have a look here: Enhanced Pivot Table

--> it is basically the same challenge.

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

Anonymous — Wed, 22 Mar 2017 22:10:28 GMT

Many thanks Robin,

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

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

Daniel_G — Fri, 03 Feb 2023 13:39:22 GMT

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