topic Re: Combining Pivot Tables into one table in QlikView

Combining Pivot Tables into one table

quilldew — Wed, 07 Feb 2018 15:10:07 GMT

Hi,

Now you're probably thinking I should have used the search function. I did, but unfortunately can't find my exact problem with a solution, so here goes

If I have a table like so:

Name	Colour	Job	City	Date
1	G	Driver	London	01/01/2016
2	R	Walker	Paris	02/01/2016
3	B	Swimmer	Paris	01/05/2016
4	R	Swimmer	NY	03/06/2016
5	G	Driver	Dakar	17/06/2016
6	B	Sleeper	Timbuktu	02/12/2017

I can create Pivot tables that look like:

I would like to be able to combine those tables so that the caption and Date line don't appear on the second table and the City lines appear directly below the Name lines, like an Excel KPI based on 'Date' would look like. ie:

Many Thanks

Re: Combining Pivot Tables into one table

sunny_talwar — Wed, 07 Feb 2018 15:22:08 GMT

Like this?

Re: Combining Pivot Tables into one table

quilldew — Thu, 08 Feb 2018 09:15:22 GMT

Hi Sunny,

That is very very useful thank you, but is there a way to keep the name of the dimension inbetween the rows, and also a way to show the subtotals of each date?

Re: Combining Pivot Tables into one table

sunny_talwar — Thu, 08 Feb 2018 09:56:42 GMT

How about something like this?

Or this

Re: Combining Pivot Tables into one table

quilldew — Thu, 08 Feb 2018 10:41:00 GMT

Perfect, many many thanks. Now researching the 'pick' function