Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
RubénHPaz
New Contributor III

Combine two pivot tables / Combina dos tablas pivotantes

I have two pivot tables with the same rows... I want to show both in only one pivot table... basically put the results of the blue box in a column on the second table (green box). Can you help me?

Tengo dos tablas con las mismas filas... Quiero mostrar ambas en solo una tabla pivotante... básicamente poner los resultados de la caja azul en una columna en la segunda tabla (caja verde). ¿Puedes ayudarme?

A.png

Labels (4)
1 Solution

Accepted Solutions

Re: Combine two pivot tables / Combina dos tablas pivotantes

Check this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
12 Replies

Re: Combine two pivot tables / Combina dos tablas pivotantes

Effort needed for sure, But can be done. Please share sample application which can reload script with inline data.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
RubénHPaz
New Contributor III

Re: Combine two pivot tables / Combina dos tablas pivotantes

Ok, there is an example of my case...

Table A and Table B are the initial info.

Results is what I looking for

Re: Combine two pivot tables / Combina dos tablas pivotantes

I apologies for delay, I was quite busy with other work. For start-up try this way?

Capture.PNG

PFA the Qlikview Document with your data

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
RubénHPaz
New Contributor III

Re: Combine two pivot tables / Combina dos tablas pivotantes

No total months? 

Re: Combine two pivot tables / Combina dos tablas pivotantes

Check this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
RubénHPaz
New Contributor III

Re: Combine two pivot tables / Combina dos tablas pivotantes

Almost, almost perfect...

I forgot to tell you something... CONDITION have no the same name in both tables... and can't have it.

This because the filters in one table can't affect the other... 

It's something like this:

TABLE 1: CONDITION_STOCK

TABLE2: CONDITION_SALES

Txs.

Re: Combine two pivot tables / Combina dos tablas pivotantes

If Data model need to maintain one primary key, I suggest you to rename the fields to constant interactive response.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
RubénHPaz
New Contributor III

Re: Combine two pivot tables / Combina dos tablas pivotantes

Perhaps yours is the unique solution... And I can't saw it... leave me check...

RubénHPaz
New Contributor III

Re: Combine two pivot tables / Combina dos tablas pivotantes

Just for this analisys I put all the stock variables with different name fields than the sales variables... Just keep the same name in CONDITION.

And your solution works without problem.

Txs.