topic How to write code for sales multiple by currency ? in QlikView

How to write code for sales multiple by currency ?

paulyeo11 — Fri, 06 Sep 2019 14:20:03 GMT

Hi All

I have a sales table.My org code :

[Row Total] AS sales,

it have CURRENCY field :-
EUR
SGD
USD

I think the new code should be :-

if (CURRENCY='USD' , [Row Total]*1.3),

if(CURRENCY='SGD' , [Row Total]*1),

if(CURRENCY='EUR' , [Row Total]*1.6) AS AMOUNT

But it cannot work.

Paul

Re: How to write code for sales multiple by currency ?

_armoco_ — Mon, 09 Sep 2019 07:55:41 GMT

Hi Paul,

Can you describe the error that you are getting?

I can see that you have renamed [Row Total] as Sales? Perhaps use Sales instead of [Row Total]? Also are you closing off all the brackets of if condition?

Re: How to write code for sales multiple by currency ?

paulyeo11 — Mon, 09 Sep 2019 07:59:32 GMT

Hi Sir

Thanbk you very much for your help. By the way some one have share with me the below script , and is working fine now.

([Row Total] * Pick(Match([Price Currency], 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) as sales,

Paul