How to make the RATE Adjustable ?

[#1]

I used a rate box in the qlikview... but the rate is fixed, i do not know how to change the rate from time to time.

Rate as in, Rate change of currency.

[#2]

I used a box for computing the Rate Change. the values are 1, 2.4, 25 and 7000. But i do not know how to change the rate without affecting the main program.

Can this be solved ?

[#3]

Hello,

if i understand you right you would like to connect the actual currency change rate to your dashboard.

i would read data from an excelfile with the columns: "currency_rate" and "country".

connect this data to the country in the dashboard. you can change the currency rate in the excelfile manually or maybe you can read the actual conversion rate from some file from your bank.

another way is to declare a variable in the script "LET v_rate_malaysia = 2.4", then include the variable in your script and change the rates in the dashboard.

regards, christian

[#4]

I created the LET, but i couldn't progress from there. Do you have any solutions leading to this? Your first step was right, but i believe there are more steps leading to this. What i want to acheive is that, when i click the rate, i can change the values of the rate, like say from, 2.4, to 2.5 or 2.6, so that my values would change accordingly,

[#5]

This is the zipped file.

[#6]

This is the file,

[#7]

Dashboard:

- New Object, "Calender/Slider Object". Select your variable there and your min-max-Value. The slider changes the value then.

- New Object, "Input Box". Select your variable here and you can change the value by typing the value.

regards, christian

[#8 · Accepted solution]

Hello Nileshrocks,

I suggest that you can use "Rate" as an input field. After the load user can input their own values into the listbox. Check this code snippet out:

//RK:
INPUTFIELD Rate;

LOAD * INLINE [
Date, Currency, Rate
2008-05-10, SINGAPORE, 1
2008-05-10, MALAYSIA, 2.4
2008-05-10, INDONESIA, 7000
2008-05-10, THAILAND, 25
];

HtH

Roland

[#9]

Thank you! It could work.