Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nakuldev
Creator
Creator

excel export merging all the data in single column

Hi,

I am facing issue while exporting data from pivot table to excel. It's just a straight forward export and not using any macros.

The export is working fine in local but while exporting from access point, all the columns are merged into one single column and column headers are also missing.   

Please find the attachment for reference.

Thanks

Nakul

Labels (2)
10 Replies
lorenzoconforti
Specialist II
Specialist II

Looks like it's just exporting a csv file. How big is the table?

Have you tried converting in Excel using Text to Columns?

Brett_Bleess
Support (Former)
Support (Former)

It would be best if you can attach a QVW on this, so we can try things, you did not mention the version you are running, that would be helpful in this case too, as want to be sure there were no known issues etc.  Need the xx.xx.xxxxx number or xx.xx SRx.  There does seem to be an issue with opening the CSV file, as I believe the other poster was correct about that part of things, if there are fewer than 65k rows, it should export as xls or xlsx, but if more than that number of rows, it will change to CSV.  There were changes to the Export to Excel in 12.30 track if I recall correctly, we started using xlsx, so if your Desktop is 12.30 but your QVServer is still running older version, that could be part of the issue too...  Best I have for the moment.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
nakuldev
Creator
Creator
Author

Hi,

There are multiple pivot tables, size ranges from 10 MB to more than 100
MB.
To do text to column in excel, I can’t suggest it to end users.

What could be the issue?

Thanks
Nakul
lorenzoconforti
Specialist II
Specialist II

How many rows is the table you are trying to export?

nakuldev
Creator
Creator
Author

Hi Brett,

QV version which we are using is 12.30, both in local and server. Records are more than 400k and Yes, it is opening in csv. For few filters it is exporting correctly but for few it is not. In final we need to extract all the data, there it is going wrong.Data is confidential to attach. 

Users were able to export earlier but recent days it started failing.

Thanks

Nakul

Brett_Bleess
Support (Former)
Support (Former)

You did not mention full version, what SR of 12.30 are you running, as I did find a defect in the Initial Release (IR) of 12.30, so if you are on 12.30.20000, that is going to be a problem, would recommend running 12.30.20300 (SR3) if that is the case.  Best I have for you at the moment.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
nakuldev
Creator
Creator
Author

Hi Brett,

I already gone through the above link and all the format is similar.

Regards

Nakul

lorenzoconforti
Specialist II
Specialist II

It appears other have had the same issue as you've had; a common solution has been to add UseIcuForLocaleInfo=0 into Setting.ini file:

https://support.qlik.com/articles/000064983

https://community.qlik.com/t5/QlikView-App-Development/November-2018-Release-Issue-with-Export-to-CS...