topic Re: Combine 2 pivot tables and conditional display in Qlik NPrinting

Combine 2 pivot tables and conditional display

adelmeire — Thu, 21 Jan 2016 08:22:12 GMT

Hi,

I'm starting with Nprinting v16. I'm trying to display 2 pivot tables in 2 differents excel sheets.

My problem is that only one table is displayed at a time in the application; they have a conditional display option that display one or the other. And in NPrinting, only the table visible in QV is visible in NPrinting.

-> How can I display the 2 tables despite de conditional display option?

My second question is how can I add a line which is the sum of the total of the 2 pivot tables?

Hope I'm clear in my explanation.

thanks for your help

Re: Combine 2 pivot tables and conditional display

Anonymous — Thu, 21 Jan 2016 11:14:05 GMT

Hi Anthony,

This thread seems to be parallel to what you are trying to accomplish. So, move one of the objects temporarily so they are not stacked on top of one another. Remove the conditional show so that you and Nprinting can see both of your objects. Build your Nprinting report and then restore the layout with the hidden charts after you have it set up.

Access to hidden tabs?

The second question is a little more complicated. Anytime you are building dynamic objects in an Excel template, it is challenging to make calculations that span more than one sheet. So, my advice to you is to build another object in QV that calculates your desired total based on the two Pivot tables. Then you can just use the results from that chart in your NPrinting template. Again, you can hide this object after you have successfully added it to your template.

HTH

Mike

Re: Combine 2 pivot tables and conditional display

Anonymous — Fri, 22 Jan 2016 13:36:47 GMT

Any update on this. Were you able to get your problem resolved?

Re: Combine 2 pivot tables and conditional display

adelmeire — Tue, 26 Jan 2016 09:31:55 GMT

My apologize. I worked on anothers tasks.

Thanks for your valuable answer. I copied the tables in a dedicated sheet where I removed the show conditional expression.

It works.