topic Re: Pivot table legend in Qlik NPrinting

Pivot table legend

markp201 — Wed, 25 Sep 2019 18:40:54 GMT

I've tried to append a plain table after a pivot table but it never shows up. I've prepending the table but it never pulls in the data. I was able to add a header to the page. Is this not possible ?

The top line is a plain table which never pulls in the rows

Re: Pivot table legend

Lech_Miszkiewicz — Wed, 13 Mar 2019 00:04:02 GMT

I don't understand what is your problem, all what i guess is that some data is not coming through, but without more details it is like searching a needle in haystack.

I would start with giving us following information:

Version of QlikView you are using.. or maybe Qlik Sense... if so - which objects do you use in your report
Version of NPrinting - is it the latest, if not = probably upgrade before we can discuss further?
Screenshots of your template, and output + expected output.
Making sure you have re-generated metadata and updated all entities in your template

cheers

Lech

Re: Pivot table legend

Ruggero_Piccoli — Wed, 13 Mar 2019 11:11:56 GMT

Hi,

Did you removed the Expand Range check for the table that is not pulling the rows?

Best Regards,

Ruggero

Re: Pivot table legend

markp201 — Wed, 13 Mar 2019 11:43:14 GMT

Weird - so the solution was to have at least 2 blank rows between the objects but this will not work if the table object is below the pivot table. I tried 5 blank rows but only the pivot table shows up.

For plain text (e.g. header) only one blank row is necessary. It may even work directly above the pivot table with no blank rows.

Re: Pivot table legend

markp201 — Wed, 13 Mar 2019 11:46:47 GMT

Thanks but tried that. Table does not show up. Have you had success combining tables and pivot tables on the same sheet?