Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to allow user adjust the exchange rate ?

Hi All

I have the below script :-

RATE:

LOAD * INLINE [

Currency_P, RATE_P

SG, 1

MY, 2.5

INDO, 8300

THAI, 25

];

Now the exchange rate fix at 8300 for SGD to Indonesia. cannot be change by user , only developer can change.

My issue :-

when the currency exchange rate for SGD to Indonesia changes to 9000 ,  i need to manually modify the above script from 8300 to 9000.

may i know it there a way i can make it dynamic . meaning user can change the value to 9000 default is 8300.

So when user click on default it will return to 8500 , and they are allow to change to 9500 or any value they like.

any solution ?

Paul

21 Replies
Not applicable
Author

Hi Ary

Many thank for your suggestion ,i just tested and fund your approach work fine.

Paul

preminqlik
Specialist II
Specialist II

HI

PFA

Regards

prem

Not applicable
Author

Hi Ary

Now i have one more question , when user change from 8300 to 9000 it work fine. this is what i want. But now i need a button to force the exchange rate change to default value. can you pls share with me how can i do it ?

Paul

Not applicable
Author

Hi Prem

Your approach work fine too. by the way i need a button to set the value to default after user any how change. can you see my file attachment or using your sample file also can,

Paul

saumyashah90
Specialist
Specialist

Hey paul,

Add one Button,

Under Action->External->Set Variable

Rate_P=Default Value


Not applicable
Author

Hi Sau

I try your approach , but it can work. further more , if 2 var change change , how to force 2 var both change to default value ?

saumyashah90
Specialist
Specialist

One i mentioned above will work for both.

Not applicable
Author

Hi Sau

Can you pls show me by file attach pls.

Paul

saumyashah90
Specialist
Specialist

Added a button call Force To default.

Default of indo=10 and SG =20

Not applicable
Author

Hi Sau

Now i understand your approach also work. i need to figure out how to implement into my exisiting script.

Paul