Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
madeleine_josef
Contributor

Data doesn't export as numbers

Hi,

How can I get the data in my table to export to excel in a number format (I want to use autosum when in Excel)?

Right now the data is opened with the format 'General' in excel and it doen't seem like I can change it.

Thanks!

9 Replies
gladi-cz
Contributor

Re: Data doesn't export as numbers

Hello,

try to call your measure with num() function.  Num( Sum(Sales) ).


BR,

Petr

agigliotti
Honored Contributor II

Re: Data doesn't export as numbers

you can apply number format for your measures.

Image 1.png

rohitk1609
Valued Contributor II

Re: Data doesn't export as numbers

If it is Qlik Sense , Num function won't work on export.

madeleine_josef
Contributor

Re: Data doesn't export as numbers

Yes, I'm using QlikSense.

rohitk1609
Valued Contributor II

Re: Data doesn't export as numbers

Can you tell me what kind of number is coming in table and how do you wana when you export it ?

matteo901p
New Contributor III

Re: Data doesn't export as numbers

Format your expression measure (right menu) in NUMBER .

If Data is a DIMENSION, you can for one moment change this in MEASURE (without sum(DATA) or other aggregations) and formatting this field like picture


Capture.PNG

rohitk1609
Valued Contributor II

Re: Data doesn't export as numbers

Thanks for your input!

Yes it is very basic one and we all know this but when self service will come , every time client need to do it to set the number format to avoid this, we must bring the expression out as we donot need to change it.

Rohit

matteo901p
New Contributor III

Re: Data doesn't export as numbers

Ciao Andrea
I think that madeleine.josefssonuse Qliksense..

madeleine_josef
Contributor

Re: Data doesn't export as numbers

I had put the value as a normal dimension, when changing it to a measure and also editing the number formatting it worked.

Thank you all!

Community Browser