topic Export to Excel Shows Different Data for Pivot Table in QlikView

Export to Excel Shows Different Data for Pivot Table

hykal1993 — Wed, 25 Nov 2020 16:16:04 GMT

I tried to use pivot table to ensure the repeated line is removed. It works

However, when I export to Excel they become duplicated. I need to export this data to Excel. Appreciate your help, thanks!

Re: Export to Excel Shows Different Data for Pivot Table

Frank_Hartmann — Tue, 30 Oct 2018 11:01:59 GMT

- right click on the table

- click on copy to clipboard

- click on Full table

- paste into excel document

Re: Export to Excel Shows Different Data for Pivot Table

vitaliichupryna — Tue, 30 Oct 2018 12:41:45 GMT

Hi Haikal,

You see duplicates because you have this duplicates in your data model/ source and Qlik always shows disctinct data in the UI objects. For example if you have a following data:

LOAD * Inline [

]

In the UI you will see:

Re: Export to Excel Shows Different Data for Pivot Table

hykal1993 — Wed, 31 Oct 2018 02:20:21 GMT

The excel file will have multiple empty lines. This does not look nice for my stakeholders. Furthermore, I'm using a Macro to generate the file to a specific path. We cannot suggest manual steps to them.

Is there a way maybe I exclude them when I'm loading the data. What should I add in the script below to only remove the row where the [Issue ID] is duplicated? The result will only show the first row of the duplicated [Issue ID].

Thanks!

LOAD

[Issue ID],

[Notification Date],

FROM