topic Re: Combine two pivot tables / Combina dos tablas pivotantes in QlikView

Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Sat, 16 Nov 2024 20:51:37 GMT

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?

Re: Combine two pivot tables / Combina dos tablas pivotantes

Anil_Babu_Samineni — Thu, 16 May 2019 04:52:17 GMT

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

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Thu, 16 May 2019 05:39:23 GMT

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

Anil_Babu_Samineni — Fri, 17 May 2019 03:09:42 GMT

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

PFA the Qlikview Document with your data

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Fri, 17 May 2019 12:39:53 GMT

No total months?

Re: Combine two pivot tables / Combina dos tablas pivotantes

Anil_Babu_Samineni — Fri, 17 May 2019 13:53:04 GMT

Check this?

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Fri, 17 May 2019 13:57:44 GMT

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

Anil_Babu_Samineni — Fri, 17 May 2019 14:06:21 GMT

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

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Fri, 17 May 2019 14:09:28 GMT

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

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Fri, 17 May 2019 14:47:38 GMT

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.

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Sat, 18 May 2019 00:56:11 GMT

Mmm... Your table hasn't the total of rows like

TOTAL US$

TOTAL UNITS

Re: Combine two pivot tables / Combina dos tablas pivotantes

Anil_Babu_Samineni — Sun, 19 May 2019 15:17:48 GMT

Are you expecting total as Row for all Condition including with Month?

We just start up something, You can try your own way like how we given the clue. For now, I can't help as I have my other stuff. I will look this either Wednesday or Saturday.

Re: Combine two pivot tables / Combina dos tablas pivotantes

RubénHPaz — Sun, 19 May 2019 18:28:42 GMT

Actually, I can to solve it.

The sinthetic dimension help me. And the Dimensionality for to choose between kinds of result's formula, instead of pick.

I accept your help like valid. Txs for to show me the way.