topic Re: load a number column in QlikView

load a number column

Mon, 11 Sep 2017 13:09:46 GMT

i need to have a list box with numbers from 0 to 100 (jump every 10)(10,20,30,,,,100)

called number.

this list box does not have to depend on nothing

i just need this number to be stored as a variable so i can use it dynamic.

sunny_talwar — Mon, 11 Sep 2017 13:11:06 GMT

Which number has to be stored? the selected number or any number in random order?

Mon, 11 Sep 2017 13:12:47 GMT

the numers 10,20,30,40,50,60,70,80,90,100

Mon, 11 Sep 2017 13:13:17 GMT

the selected

sunny_talwar — Mon, 11 Sep 2017 13:16:29 GMT

You can either store it directly like this

vVar

=FieldName

or use a trigger to save the value to the variable

Mon, 11 Sep 2017 13:17:54 GMT

can u write me the entire script please

sunny_talwar — Mon, 11 Sep 2017 13:22:48 GMT

Look at the attached file

Anil_Babu_Samineni — Mon, 11 Sep 2017 13:26:46 GMT

Or may be this, If more than one

=Concat(FieldName, ',')

Mon, 11 Sep 2017 13:28:25 GMT

i dont have a field/

i need one

marcus_malinow — Mon, 11 Sep 2017 13:29:24 GMT

Sounds like you just need an Inputbox.

Set one up with a variable of your choosing, with the following settings