topic Re: how to do a report with header table and expandable detail in App Development

how to do a report with header table and expandable detail

MassimoT — Fri, 16 May 2025 13:14:26 GMT

I need to figure out how to make the following data representation. I want to publish a table of headers containing various fields and expand the details (many fields too) for the desired headers within a single report. i'm intersted only of two levels. Can anyone help me?

Re: how to do a report with header table and expandable detail

henrikalmen — Fri, 16 May 2025 19:32:15 GMT

I'm not quite sure what you are asking for. Have you tried the pivot table object?

Re: how to do a report with header table and expandable detail

MassimoT — Mon, 19 May 2025 06:46:34 GMT

Hi, the pivot table is not good because the data I have to show is different between header and detail. I'll give an example to clarify. I have a contract object and a contract detail object, in the contract I want to show the customer, the contract amount and other general data. When I expand a single contract I want to show detail data such as the items that are part of the contract and more. I could use a view with two tables, but the requester would like to have a single report with the detail expandable.

Re: how to do a report with header table and expandable detail

henrikalmen — Mon, 19 May 2025 08:24:42 GMT

I believe you need to look for a third party extension. Hopefully you can find one that can do that. But I don't see how you could achieve that with the native objects in Qlik Sense.

Re: how to do a report with header table and expandable detail

MassimoT — Mon, 19 May 2025 09:26:20 GMT

Thanks,

I actually looked for third-party applications, but the only one I found is paid. For now I made a group where I inserted the two header and detail tables and this allows you to download the query result in a single pdf report, but it is not possible in excel.