Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to avoid duplicates when export to excel?

Hi,

I have one table which have dimension CustomerID with duplicates. for each CustomerID there are multiple unique ID. My user don't want to see duplicates in CustomerID when exported to excel. but wants all CustomerID with ID. so, I used Pivot table. In qvw it is showing only once instance of CustomerID with ID, but when exporting to excel it is showing duplicate CustomerID.

How to sort this out. Can anyone help me please.

Thanks.

24 Replies
jsaradhi
Valued Contributor

Re: How to avoid duplicates when export to excel?

in your other thread for the same requirement, tresco's response which you marked as the helpful answer, is the way to go about your requirement.

Not applicable

Re: How to avoid duplicates when export to excel?

Thanks. I showed the one to the user which I marked as helpful answer. But the user don't want that format. why I marked it as helpful is as others can help from this helpful answer. if any one have this issue and anyone is ok( as it will be different in different organisations) with that format.

Please any other solution.

Not applicable

Re: How to avoid duplicates when export to excel?

Please any solution?

Partner
Partner

Re: How to avoid duplicates when export to excel?

Use STORE

Store will allow you to define the output fields, and you can create a CSV file for excel to read. Your user can open the file instead of exporting the pivot.

By using Resident, Distinct, Group By etc. you can build a table for excel, and then DROP it when you have finished:

Store

CustomerID,

MyfieldB as b

from mytable into xyz.csv (txt);

DROP Table mytable

Regards,

Marty.

Re: How to avoid duplicates when export to excel?

Hi,

Can you post some sample data to explore.

You need to use macro here.

If you can post sample then I would give it a try.

Regards

ASHFAQ

Partner
Partner

Re: How to avoid duplicates when export to excel?

Alternatively, create a Pivot just for export, with the required columns, and leave it minimised.  Instruct the user to right click on that control instead of the displayed version.

Regards,

Marty.

sujeetsingh
Honored Contributor III

Re: How to avoid duplicates when export to excel?

It will be good to use some macro but it will be much complex.

Not applicable

Re: How to avoid duplicates when export to excel?

Thanks. Please see attached sample and help me.

Not applicable

Re: How to avoid duplicates when export to excel?

Thanks. I tried this and still showing the duplicates.