Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

mysail25
Contributor

Create Page Level with Pivot table inside

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

Tags (1)
7 Replies
devarasu07
Honored Contributor II

Re: Create Page Level with Pivot table inside

mysail25
Contributor

Re: Create Page Level with Pivot table inside

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

devarasu07
Honored Contributor II

Re: Create Page Level with Pivot table inside

Hi,

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

Capture.JPG

mysail25
Contributor

Re: Create Page Level with Pivot table inside

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.

devarasu07
Honored Contributor II

Re: Create Page Level with Pivot table inside

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

mysail25
Contributor

Re: Create Page Level with Pivot table inside

Hi deva,

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

devarasu07
Honored Contributor II

Re: Create Page Level with Pivot table inside

Hi,

Refer to the attached output,

Capture.JPG

Community Browser