Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Pound sign on Currency

Hello,

I am trying to determine currency format according to the cusyomer by using this formula in my expression:

if(Division ='A' , num(sum((qty*price)+(Discount/Gross_Revenue)*(qty*price))/sum(qty),'$#,##0.00'),
if(Division ='B' and CurrencyCode = 'GB' , num(sum((qty*price)+(Discount/Gross_Revenue)*(qty*price))/sum(qty),'£#,##0.00'),
if(Division ='B' and CurrencyCode = 'EU' , num(sum((qty*price)+(Discount/Gross_Revenue)*(qty*price))/sum(qty),'€#,##0.00'))))

So I am getting three different currencies.

Everything works good on qlikview, but when I pull out the data to excel, it does not read the numbers with pound sign as number, but as text so I can not do any calculation with this number. The numbers with dollar and euro signs work good.

I tried diferent thing on excel to reformat cells but it does not work.

Anybody any thoughts what causing the prblem with the pound sign?

Thanks

Denis

2 Replies

Re: Pound sign on Currency

Formating-function are generally difficult by exporting to excel because than excel interpreted the values on a own logic which is often not wanted. You could convert these values manually or per macro but easier will be to use two columns - one with value and one with the currency.

- Marcus

Not applicable

Re: Pound sign on Currency

HI Marcus,

Thank you for quick replay.

The problem is that excel reading correct the numbers with dollar and euro signs, the problem is only with GBP sign.

So I was thinking there is a way to deal with that on qlikview formating instead of manually change it on excel?

Thanks.

Denis

Community Browser