Num format while pulling to excel

[manoranjan_d]

Hi all,

in my expression i use num format function as per the requirement and  given as properties --> format as measure expression, but when i pull the data in excel (export or download) the numbers are in text in excel. how to resolve this.

i agree if i  change the format  to -->number, its fine ,but in the expression i have formatted with num since i use multiple expression with if loop as per the metric selection.

example if user select metric 1 then the num be shd in % calculation , if user select metric 2 then it shd be in the 1,000 format. so in the exp i have given the num format and as per the selection the format displaying correctly in the chart, but while pulling the data  in excel its in text.

[dplr-rn]

can you share your expression?

[CraigB]

HI there:

[-TermsOfPaymentID] and =SalesRep
It show as below, and visual, which I want it.

[cid:image001.png@01D55804.71D1DC70]
Thank you.







Best Regards,
Craig Bolton
Pre Sales Consultant
770-861-0604 M
Craig.bolton@iptor.com

[test-2]
Join us in a Connected World ► Learn More
[LinkedIn-header-icon-email-sig] [Twitter-header-icon-email-sig] [Vimeo-header-icon-email-sig]




[Iptor-Pride-1]
Join us in a Connected World ► Learn More
[LinkedIn-header-icon-email-sig] [Twitter-header-icon-email-sig] [Vimeo-header-icon-email-sig] [Instagram-header-icon]

[dplr-rn]

Images are not visible

[manoranjan_d]

not visible

[manoranjan_d]

if(MetricId=2,

       Num( (Sum(Gross sales))/ (Sum(total(Gross sales))) ,'#,##0.0%'),

Num( Sum(Gross sales)          

    ,'#,##0')

)

Number Format-->Measure Expression 

[dplr-rn]

Looks all right. I am assuming it is a user selection which determines the expression

Are you using a straight table? or pivot?

[manoranjan_d]

its qliksense straight table(table chart)  my issue is while pulling (export data )in to excel the number are in text format in excel.

my expression works fine and good.

[manoranjan_d]

any updates