topic Re: Data is duplicating while Exporting data into excel in QlikView

Data is duplicating while Exporting data into excel

Tue, 10 Dec 2013 00:49:11 GMT

Hi All,

When I am exporting data into csv or in excel , if count of rows is more than 65000 so in one field that is in first dimension data is duplicating it is coming twice.

Any idea how to resolve it?

Re: Data is duplicating while Exporting data into excel

jagan — Tue, 10 Dec 2013 03:21:12 GMT

Hi,

Can you attach some sample file, it helps in understanding the issue.

Regards,

Jagan.

Re: Data is duplicating while Exporting data into excel

Fri, 13 Dec 2013 01:18:37 GMT

Hi,

Issue is resolnved after changing the sequence of dimension in straight table.

Thanks

Re: Data is duplicating while Exporting data into excel

Tue, 18 Nov 2014 15:43:15 GMT

Hi,

I have the same problem with a straight table of huge dimension.

To confirm this, I've tried to export with smaller data the same rows that seem to have different dimensions on the large export, and works well, so I think the problem is related to the number of rows in the original table.

Could you please better explain what workaround did you implemented?

Thanks in advance

Luca

Re: Data is duplicating while Exporting data into excel

Thu, 20 Nov 2014 10:24:17 GMT

Try to change the sequence of dimension. Because it worked for me.

Regards

Sumita