topic Re: Combine two different pivot tables in QlikView

Combine two different pivot tables

Thu, 22 May 2014 12:50:29 GMT

I have two separate pivot tables and I would like to combine the totals from the two tables together. Is there a way to do this????

Re: Combine two different pivot tables

arthur_dom — Thu, 22 May 2014 13:00:52 GMT

could you be more specific?

Re: Combine two different pivot tables

Thu, 22 May 2014 13:07:01 GMT

As you can see, I have two different pivot tables here. I would like to take the totals from the top pivot table and add them to the totals in the second pivot table.

For instance:

For Quarter 14Q2 under DOM I have 39734 and on the second table I have 5440 which gives me a total of 45174

Re: Combine two different pivot tables

Anonymous — Thu, 22 May 2014 13:10:29 GMT

Hello,

I am also have same issue. I want to show just total column of other pivot to other pivot data.

Which can very easy in Excel

Thanks & Regards

Kiran Kokade

Re: Combine two different pivot tables

Thu, 22 May 2014 13:20:14 GMT

Try with set analysis or send test.qvw

Regards,

Chinni Kanna