this example solves your specific problem (since I can't reload your script).
However, If I could reload, I would do it differently alltotgether:
1. Create an inline table in your script. E.g. something like
LOAD * INLINE [
This way your color will be an actual dimension, where your users can choose from given colors. My variable in the example actually does almost the same thing. The difference is that you manage your data in the frontend, not the script, which I generally would advise.
2. After creating this dimension, all you need to change is your color formula to include your dimension in the if statement, add a select field - and voila - your users can choose from the dimension.
Hope this helps you out.
Contract input color.qvw 159.2 K
Thanks a lot for your reply.
The color is not given in input, it is planned like based on the review on the progress made on contract, The color of contract will be decided by the management user.
So i want a filed where the user can select a color "Red", "Yellow" or "Green", which will get saved in the qlikview file & alos affect the color of respective contract in the bubble chart.
I have enclosed the the input file, As i am very new to qlikview was not able to completely try out & understands your instructions (sorry for that).
Enclosed below is the color concept & the input file.
Question.xlsx 9.1 K
If I understand your problem you want to be able to input data within the QlikView app and then have that data saved back to the database?
If this is the case then you might not be able to get this to work without a lot of learning and hard work. It is possible to use a macro to write back to a database but this is unsupported and complicated. You will also only be able to update a single row at a time if you are manually setting the status with an input field.
The long and short of it is that QlikView is a reporting tool and not a data entry system or database. Although you can bend it a little bit this might not be the simplest solution.
Sorry I couldn't give you an easy solution