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: 
parthakk
Creator II
Creator II

Export To Excel - Qlik Sense

Hi Everyone,

I have a table which has multiple dimension and no measure added. One of these dimension is in number format (Say Column-N). Upon exporting to excel this particular column displays in improper format as 123456+E and so on.

However, i am aware of the fact that upon adding it to measure, it shall solve the issue but the problem is if we add Column-N to measure then irrespective of the order in table, it shifts to last column. I want it to be in particular order so as to make sense for analysis.

Kindly suggest how can i achieve this.

Thanks,

Partha K

2 Replies
MK9885
Master II
Master II

Maybe use below in your script as Incremental load?

Load*,

num#(YourDimension,'#######') as YourNewDimension;

Load

.....

And use YourNewDimension in front end as dimension to show?

I'm not sure about my statement but Num() in script should solve your issue or check the Number formatting in properties for your chart,

micheledenardi
Specialist II
Specialist II

Look at this:

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/DataExport/export-data.htm

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.