send to excel with Expression Default

[settu_periasamy]

Hi All,

When  i use send to excel for the Chart, i'm not getting the correct format. 

i'm using the expression default in the Number tab.

=num(sum(Sales),'#,##0', '.' , ',')   - For integer

=num(Sum(Sales)/Sum(Days),'#,##0.0%', '.' , ',')  - For Percentage

I tried the ExcelExportMixedasText. It's working for Integer format.

But , I need to show the Percentage(%) value also in the correct format.

see the below screen shot.

help me on this.

[nagarjuna_kotha]

Hi,

Can u share ur Excel sheet.

Regards,

Nagarjuna

[robert_mika]

Which version are you using?

Have you read this doc?

[settu_periasamy]

Yes Robert. Already i read that doc.

My Qlikview version is 11.2 SR9

I do not have problem with numbers. But the percentage value having the problem.

Sample qvw is attached.

[robert_mika]

Which is the correct format you want to achieve?

[settu_periasamy]

Hi Robert,

I do not have problem with showing the value in QV. But, while using the send to excel, the "Expression default" is not working as expected.

see the below screen shot

Thanks.

[settu_periasamy]

Any suggestions?

[Anonymous]

any updates on this issue ?