Pivot Table from Page Level Created Tab

[Brip51]

I am using Qlik Cloud Reporting and I have an excel template. I have created page levels to cycle through the Currency Type field to create 3 Excel Tabs- Functional, Reporting, and Original.

I want to insert a pivot table from the Reporting tab, but that gets created on the fly by the page level tag.

I can insert a pivot table by the standard way - adding columns from the table, but if I filter to Reporting Currency Type the page level only Reporting.  If I do not filter the Currency Type I get the three Tabs -  Functional, Reporting, and Original but the pivot table uses the first tab (Functional)

How can I insert a pivot table from a tab that is created from a page level on the fly?

Any help would be greatly appreciated.

Thanks,

Brian

[Chanty4u · Accepted solution]

Hi

A native Excel PivotTable cannot be placed inside a Qlik level, but it can be placed on a worksheet that uses a Qlik page 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/t...?

https://help.qlik.com/en-us/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/a...?

Check above links 

[Lech_Miszkiewicz · Accepted solution]

Hi @Brip51 

This is hard to do but not impossible!

It is a matter of using the same sheet for pivot table and straight table data. We don't know your data volume or your pivot table size once it gets created so I am not sure if its possible. My way of working with it is to populate straight table data say from row 10000 downwards allowing rows 1-10000 to be used for a pivot table and referencing it as a named table instead of cells range.

That method works (cause I test my answers so I know 😁) and for every new sheet you get pivot table pointing to source table from the same sheet.

hope that helps.

cheers

[Brip51]

Hi Lech,

Thank you for tip.  

This will work (as you pointed out 🙂 

My requirement is to create the pivot on a separate Excel Tab.

I think I will create a sheet for each Currency Type in the Qlik app.

Regards,

Brian

[Brip51]

Thanks.  I marked both as solutions as putting the Pivot on the same page as the data was mentioned.  Thank you for the help!