topic Re: Pivot Table from Page Level Created Tab in Reporting Service & Alerting

Pivot Table from Page Level Created Tab

Brip51 — Wed, 26 Aug 2026 13:24:49 GMT

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

Re: Pivot Table from Page Level Created Tab

Chanty4u — Wed, 26 Aug 2026 18:16:22 GMT

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/tabular-report-example.htm?

https://help.qlik.com/en-us/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/Excel/add-in-excel-native-tables.htm?

Check above links

Re: Pivot Table from Page Level Created Tab

Lech_Miszkiewicz — Wed, 26 Aug 2026 23:14:25 GMT

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

Re: Pivot Table from Page Level Created Tab

Brip51 — Wed, 09 Sep 2026 13:09:30 GMT

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

Re: Pivot Table from Page Level Created Tab

Brip51 — Wed, 09 Sep 2026 13:11:39 GMT

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