topic Re: excel export not working correctly when using expression default in QlikView

excel export not working correctly when using expression default

felcar2013 — Wed, 13 Nov 2013 13:44:03 GMT

dear community

i have some formulas represented as variables in the script. i formatted them using num() and under chart properties / number / number format settings, i use "expression default".

in the script i declared the variables like: set vRedemptionRate = num($(vRedemption)/$(vRecipients),'#.##0,0%');

i have realized that when i export a table to excel, it exports the percentage numbers as decimal with many numbers after the "comma" or decimal point

but if i set under Number Format Settings, "fixed to" (for decimals) and " show in percent", then the export to excel is correct.

Why using the variables and the "expression default" it does not work correctly?

thanks for the help

felipe

Re: excel export not working correctly when using expression default

vadimtsushko — Sat, 01 Feb 2014 16:47:56 GMT

Hi, Felipe.

I've recently found that while Num() function does not work with 'Send to Excel', Money() function actually does work.

So in your sample Money($(vRedemption)/$(vRecipients),'#.##0,0%') should work (looks funny I know)

Tested on QV11 SR4 and SR5

Best regards, Vadim Tsushko

Re: excel export not working correctly when using expression default

felcar2013 — Tue, 04 Feb 2014 13:37:26 GMT

Thanks Vadim, is good to know