Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discuss and learn more about Qlik Sense app development and usage.
Hello @simospa,
I believe that @vikasmahajan is right. Exporting the table directly from Pivot table to EXCEL will keep merging the cells of the same dimension instead of writing the same dimension value on each cell.
The only workaround is to temporarily convert the Pivot table into a Straight table and then export the data. For example:
1. Make a copy of your table and expand all the rows:
2. Now click on "Edi sheet" and from the left panel find the Table chart so you could add it on the sheet
3. Drag the Table chart on the second Pivot table and choose "Convert to: Table"
4. Export the Table chart as EXCEL and you will get:
5. Now you can just delete the temporary Table chart
If you would like the Pivot table to have the same export functionality as it has in QlikView, then you can submit a feature request [1]
I hope that this information is helpful.
---