Discussion board where members can get started with Qlik Sense.
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.
try to call your measure with num() function. Num( Sum(Sales) ).
you can apply number format for your measures.
If it is Qlik Sense , Num function won't work on export.
Yes, I'm using QlikSense.
Can you tell me what kind of number is coming in table and how do you wana when you export it ?
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
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.
Ciao Andrea I think that madeleine.josefssonuse Qliksense..
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!