topic Input Box set initial variable value in QlikView

Input Box set initial variable value

picturebox — Mon, 07 Feb 2011 14:32:43 GMT

Hello,

My input box allows the user to select from a list of Listed Values which I read into a variable named vPickList. There is an inital setting for the selected variable which can be set. I would like to set this to be the first value from my pick list vPickList. vPickList is also a dynamic List which is incremented at each reload, so a constant value here won't help me. I know there is a function out there, but I cannot remember which I need to use for this ...

Thanks,

Petra

Input Box set initial variable value

rbecher — Mon, 07 Feb 2011 15:50:23 GMT

Hi Petra,

you could set the input varaible in the script with the first value from vPicklist.

- Ralf

Input Box set initial variable value

picturebox — Mon, 07 Feb 2011 16:23:36 GMT

Hi Ralf,

I don't have access to the script as I do a binary load and would like to put that into the chart ... I am looking for a formula that will give me the first value of that vPickList .... my head does not want to find it at the moment!

Thanks,

Petra