topic Currency formats in QlikView

Currency formats

Tue, 04 Oct 2011 09:00:13 GMT

Hi everyone,

I came across a problem that I don't know how to solve.

I downloaded data and the amount looks like this:

Amount

38,362 EUR

39,398 EUR

37,210 EUR

$ -1,939

$ -2,332

$ -541

1,055,555 DKK

508,908 DKK

I would like to have a field with only amount and also additional field with currency, so that all lines look the same and it is easy to convert the amounts to diff. currencies..

Amount Doc.Currency

38,362 EUR

-1,939 USD

However, because curr. indicators are both at the beginning or at the back of the amount, I dont know how to handle this. Please help.

Currency formats

kaushiknsolanki — Tue, 04 Oct 2011 09:13:52 GMT

Hi,

You can try this way.

Load

Keepchar(Field,'1234567890') as Amt,

Purgchar(Field,'1234567890-') as Curr

From xyz.

Regards,

Kaushik Solanki

Re: Currency formats

Sokkorn — Tue, 04 Oct 2011 09:19:39 GMT

Hi,

Check in the attached file.

Hope this help you.

Regards,

Sokkorn

Currency formats

Tue, 04 Oct 2011 09:24:17 GMT

Thank you, it worked:)