topic Re: How to write a expression when reload it will convert all diff currency to SGD $ in QlikView

How to write a expression when reload it will convert all diff currency to SGD $

paulyeo11 — Tue, 02 Sep 2014 12:43:26 GMT

Hi All

I create this expression at table column for 30DaySGD , it work fine :-

IF(CURRENCY='EUR',COLUMN(1)*1.64,

IF(CURRENCY='NT',COLUMN(1)/24,

IF(CURRENCY='USD',COLUMN(1)*1.25,

IF(CURRENCY='YEN',COLUMN(1)*0.012,

IF(CURRENCY='SGD',COLUMN(1)*1))

)))

My load script have following field :-

@220:223T as [CURRENCY],

@92:106T as [30DAY_],

@107:108T as [30SIGN],

if(@107:108T = '-',@92:106T*-1,@92:106T) as DAY30,

May i know how to write the expression , so that when it load script , it will create the field for Day30SGD ?

Paul

Re: How to write a expression when reload it will convert all diff currency to SGD $

paulyeo11 — Tue, 02 Sep 2014 12:44:58 GMT

My QV doc.

Re: Re: How to write a expression when reload it will convert all diff currency to SGD $

mvanlutterveld — Tue, 02 Sep 2014 14:04:08 GMT

Hi Paul,

I solved your issue by using a preceding load. Take a look at the attachement.

Cheers,

Michiel

Re: How to write a expression when reload it will convert all diff currency to SGD $

paulyeo11 — Wed, 03 Sep 2014 00:34:30 GMT

Hi Michiel

Thank you very much , you are right partial reload is the right apporach . also load script make my expression more simple and less error , now i can move on,

Paul