topic Re: Create Page Level with Pivot table inside in Qlik NPrinting

Create Page Level with Pivot table inside

Anonymous — Tue, 19 Dec 2017 02:47:00 GMT

Hi everyone,

In sheet 1(Data): I've column data as Area, Country and Value. In other sheet I created pivot based on sheet 1

I've problem to split pivot table to another sheet based on value of Area.

Here I attached sample of my template in Nprinting.

Thanks for your answer n support

Re: Create Page Level with Pivot table inside

devarasu07 — Tue, 19 Dec 2017 03:23:40 GMT

Hi,

have you tried like this way?

How to Use the Page Feature in Excel and PowerPoint Report Templates

Re: Create Page Level with Pivot table inside

Anonymous — Tue, 19 Dec 2017 03:47:05 GMT

It will worked if my data as straigth table, but in my case it show as pivot table in sheet.

Re: Create Page Level with Pivot table inside

devarasu07 — Tue, 19 Dec 2017 04:04:43 GMT

Hi,

yes, refer to the attached sample project (i've used straight table, page & level with pivot table)

Re: Create Page Level with Pivot table inside

Anonymous — Tue, 19 Dec 2017 05:59:59 GMT

Hi Deva,

In your example,source table in sheet1 just one row not all data in table.

I've same issue like your sample, when I split sheet by Area (in your case is Year) it split sheet to all value of Area but result of pivot table is same as original pivot.

Re: Create Page Level with Pivot table inside

devarasu07 — Tue, 19 Dec 2017 06:04:16 GMT

Hi,

I've used dummy data, your case it should work. if still not working would be able to share your mock app and expected output.

Thanks

Deva

Re: Create Page Level with Pivot table inside

Anonymous — Tue, 19 Dec 2017 07:30:27 GMT

Hi deva,

Here I attached my mockup app, I used all field in template nprinting.

Re: Create Page Level with Pivot table inside

devarasu07 — Tue, 19 Dec 2017 08:45:43 GMT

Hi,

Refer to the attached output,