Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add currency sign dynamic using load script ?

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

0 Replies