topic Re: send to excel with Expression Default in QlikView

send to excel with Expression Default

settu_periasamy — Mon, 27 Apr 2015 03:06:45 GMT

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 — Mon, 27 Apr 2015 05:01:12 GMT

Hi,

Can u share ur Excel sheet.

Regards,

Nagarjuna

robert_mika — Mon, 27 Apr 2015 06:29:35 GMT

Which version are you using?

Have you read this doc?

settu_periasamy — Mon, 27 Apr 2015 06:54:06 GMT

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 — Mon, 27 Apr 2015 11:36:07 GMT

Which is the correct format you want to achieve?

settu_periasamy — Tue, 28 Apr 2015 01:51:03 GMT

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 — Tue, 28 Apr 2015 06:40:26 GMT

Any suggestions?

Anonymous — Sun, 18 Oct 2015 10:15:10 GMT

any updates on this issue ?