Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RubénHPaz
Contributor III
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)
12 Replies
RubénHPaz
Contributor III
Contributor III
Author

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

TOTAL US$

TOTAL UNITS

Anil_Babu_Samineni

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.

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
Contributor III
Contributor III
Author

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. 

 

A.png