Export to Excel Shows Different Data for Pivot Table

[hykal1993]

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!

[Frank_Hartmann]

- right click on the table

- click on copy to clipboard

- click on Full table

- paste into excel document

[vitaliichupryna]

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 [

ID

1,

2,

2,

3,

4

]

In the UI you will see:

ID

1

2

3

4

[hykal1993]

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