Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issues with exporting data to Excel in QlikSense

In QlikSense, when we export data of a chart / table , the measure values doesn't appear in the proper format. I want to see the values as numbers but it gets displayed in the 'e' format. Some times the numbers are shown as text in Excel.


This is not working out even if we apply num format (we know this is used for proper number representation in UI only).

If we use Round function values are mismatching with some decimal number differences.


I think qlik should have a mechanism to export data with proper formatting.


Thanks

Chenna

10 Replies
Anonymous
Not applicable
Author

Hi Chenna,

To repeat your problem, could you send an example Excel file and also your qvf file.

BW,

Markus

andrespa
Specialist
Specialist

Hi Chenna, this is a common issue and I think it has to be more with excel than with Qliksense. Have a look at this article that might help:

Why does my exported CSV data get converted to weird formats?

Hope it helps,

Andrés

Anonymous
Not applicable
Author

Hi Markus,

I have attached sample QVF file with the excel file exported

Thanks,

Chenna

beck_bakytbek
Master
Master

Hi Chenna,

here are many Information to your issue: qlickblog.at

i hope that helps

beck

Anonymous
Not applicable
Author

Hi Beck,

I can't access this link

Can you share the correct url?

Thanks

Chenna

Anonymous
Not applicable
Author

Hi Chenna,

I checked your files, seems like numbers shown in Excel are in 'E' -format, but that's only a format and those are actual numbers shown in Excel address bar. There is #,0#############E+### format used in Excel. Below there is a picture of Excel format and in address bar there is actual number:

Excel_format_pic.png

I loaded that Excel file to Sense and numbers are correct, those are actual numbers because Sense don't transfer formats, only actual cell values. Below there is a picture of Sense after Excel connect and reload:

Sense_format_pic.png

 

BW,

Markus

Anonymous
Not applicable
Author

Hi Markus,

Thanks for the update.

But what is the mechanism when we export data from Qlik to Excel,

I feel it (excel) should display the data same way it is in Qlik report.

Are there any settings we can do in Qlik?.

Thanks

Chenna

Anonymous
Not applicable
Author

Hi Chenna,

I found an Sense option which shows correct formats in Excel. You can use custom number settings:

Sense_format_pic_export.png

Then settings will be right in Excel also:

Excel_format_pic_export.png

BW,

Markus

Anonymous
Not applicable
Author

Hi Markus,

I have tried this method earlier and worked as expected.

But I want this to be driven through expressions by applying Num format. The reason for this is I have many expressions with different formats and used in different objects. If I have to manage same format, I have only option to apply the format with in the expression and use it as many places as I can.

Let me know if I'm thinking something wrong.

Thanks

Chenna