how to do a report with header table and expandable detail
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?
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.
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.
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.
