Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

parthakk
Contributor 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
Khan_Mohammed
Honored Contributor II

Re: Export To Excel - Qlik Sense

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
Valued Contributor

Re: Export To Excel - Qlik Sense

Community Browser