How to add currency sign dynamic using load script ?

Mon, 26 Jan 2026 18:19:17 GMT

Hi All

when user select :-

BRAND_P=BECKHOFF , PRICELIST to display EURO123

BRAND_P=GE , PRICELIST to display USD123

BRAND_P=HAKKO , PRICELIST to display USD123

BRAND_P=MITSUBISHI , PRICELIST to display SGD123

Right now my Script is below :-

left join (PRICE)

Load PART_NO_,

'USD '& LIST_PRICE as PRICELIST

Resident PRICE;

it make all PRICLIST filed fill with USD.

I like Pick and match , so i try it but cannot work , may be i need to add more code :-

Pick(Match(BRAND_P,'BECKHOFF','GE','HAKKO','MITSUBISHI'),'EURO','USA','USA,'SGD')& LIST_PRICE as PRICELIST

topic How to add currency sign dynamic using load script ? in QlikView