Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hykal1993
Contributor II
Contributor II

Export to Excel Shows Different Data for Pivot Table

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

Capture.PNG

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

Capture1.PNG

3 Replies
Frank_Hartmann
Master II
Master II

- right click on the table

- click on copy to clipboard

- click on Full table

- paste into excel document

vitaliichupryna
Creator III
Creator III

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
Contributor II
Contributor II
Author

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