Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

quilldew
Contributor

Combining Pivot Tables into one table

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:

  

NameColourJobCityDate
1GDriverLondon01/01/2016
2RWalkerParis02/01/2016
3BSwimmerParis01/05/2016
4RSwimmerNY03/06/2016
5GDriverDakar17/06/2016
6BSleeperTimbuktu02/12/2017

I can create Pivot tables that look like:

pivotmerge test1.JPG

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:

pivotmerge test2.JPG

Many Thanks

1 Solution

Accepted Solutions

Re: Combining Pivot Tables into one table

How about something like this?

Capture.PNG

Or this

Capture.PNG

4 Replies

Re: Combining Pivot Tables into one table

Like this?

Capture.PNG

quilldew
Contributor

Re: Combining Pivot Tables into one table

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

How about something like this?

Capture.PNG

Or this

Capture.PNG

quilldew
Contributor

Re: Combining Pivot Tables into one table

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

Community Browser