Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

Week1Week2Week3Week 4MonthYear
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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

have a look here: Enhanced Pivot Table

--> it is basically the same challenge.

View solution in original post

3 Replies
Anonymous
Not applicable
Author

have a look here: Enhanced Pivot Table

--> it is basically the same challenge.

Anonymous
Not applicable
Author

Many thanks Robin,

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

Daniel_G
Partner - Creator
Partner - Creator

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