Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Can u share ur Excel sheet.
Regards,
Nagarjuna
Which version are you using?
Have you read this doc?
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.
Which is the correct format you want to achieve?
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.
Any suggestions?
any updates on this issue ?