topic Re: Currency Formating in QlikView

Currency Formating

bnelson111 — Thu, 20 Mar 2014 11:40:34 GMT

Currency Format. I have a straight sum table image below, as you can see the currency is Euro and GBP, I have used if statements to conditional format the values but they don't always correspond is there another way instead of IF? Remember is row changes so standard format wont work?

Re: Currency Formating

its_anandrjs — Thu, 20 Mar 2014 11:46:37 GMT

Hi,

Try to load currency mapping table with its value.

Thanks & Regards

Re: Currency Formating

MK_QSL — Thu, 20 Mar 2014 11:47:11 GMT

IF(CurrencyCode = 'GBP', MONEY(YourExpression, '£#,##0.00', '€#,##0.00')

Hope this helps...

Re: Currency Formating

jonathandienst — Thu, 20 Mar 2014 11:50:29 GMT

If you are controlling the currency format using Num() or Money() statements in the expression, you need to set the format in Properties | Number to 'Expression Default'.

HTH

Jonathan

Re: Currency Formating

PrashantSangle — Thu, 20 Mar 2014 11:55:07 GMT

You can create inline table and link that table with your table

currency:

LOAD * Inline

[

Local,val

AUD,1.0908

CAD,1.0187

EUR,0.7399

GBP,0.6650

USD,1.000

];

and create variable as vCur

assign value =val

and in your expression

=Sum(Sales)*vCur

Regards

Re: Currency Formating

Thu, 20 Mar 2014 12:03:25 GMT

You can use Number to 'Expression Default' and expression like this with any CurrCode and formats:

num(sum(Value),Pick(Match(CurrCode,'EUR','GBR'),'€ # ##0,00;€ -# ##0,00', '£ # ##0,00;£ -# ##0,00'))

Re: Currency Formating

sunilkumarqv — Thu, 20 Mar 2014 12:12:02 GMT

You can try like these

suggested By John

Re: Currency Formating

bnelson111 — Thu, 20 Mar 2014 12:45:25 GMT

Thanks, brilliant