topic Re: multicurrency change cell value when export to excel in QlikView

multicurrency change cell value when export to excel

Tue, 09 Oct 2012 13:52:15 GMT

i have a problem.

I work with a multicurrency QV,

we need before to select a currency

in a table we do price multiplie by the corresponding change and is the corresponding format.

i add(a qvw) whit this, this is not the problem.

We have solved this problem with the following formula:

num(sum(precio)*Cambio,FORMATO)

when change = 1,2134

and format= $#.##0,00 ;$-#.##0,00

this is all right, but if we export this table to excel, the cell value(data) is consider like a text and we can´t do opertations in excel like sum for example...

Re: multicurrency change cell value when export to excel

Anonymous — Wed, 10 Oct 2012 08:40:33 GMT

check attached..

hope that helps..

Re: multicurrency change cell value when export to excel

Wed, 10 Oct 2012 09:48:43 GMT

It seems to be a solution, even that would fail to keep the currency format when exporting to excel, you would know how?

thanks

Re: multicurrency change cell value when export to excel

Anonymous — Wed, 10 Oct 2012 11:20:41 GMT

hi christina

have alook at the attached qvw.

regards,

vaibhav

Re: multicurrency change cell value when export to excel

Anonymous — Wed, 10 Oct 2012 12:13:31 GMT

hey christina did u get the solution?

Re: multicurrency change cell value when export to excel

Wed, 10 Oct 2012 14:19:02 GMT

No, I need to have the table in QlikView with the selected currency format and exporting to excel the field has the currency format and can be added to that format excel cells can not be text, as is in the solution that you sent.

thank you very much