topic How to set a set of values into variable? in QlikView

How to set a set of values into variable?

Mon, 27 Dec 2010 15:50:58 GMT

Hi all,

I open setting menu>variable overview, I would like to set a set of values into one variable.

For example:

VarTest: 1,2,3

How can I get it?

Thanks.

syed_muzammil — Mon, 27 Dec 2010 15:52:47 GMT

Hi,

If the Values are being taken from a field then you can use Concat function of Qlikview .

Mon, 27 Dec 2010 15:56:16 GMT

Thanks for your answer, I would like to set some static values for it. How can I achieve it?

Miguel_Angel_Baeyens — Mon, 27 Dec 2010 16:19:20 GMT

Hi Isaac,

If the values you want to set are numeric, you can set them in the Variable Overview as you already did. If they are strings, you have to quote them

'A','B','C'

Then you can retrieve them in your charts using Pick()

Pick(1, $(variableName))

will return "A".

Bear in mind that there are not "arrays" as such in QlikView.

Hope this helps.

Mon, 27 Dec 2010 16:28:54 GMT

Hi,

But when I set it as 'A','B','C' in Variable Overview , there is an error message alerts: garbage after "," .

Miguel_Angel_Baeyens — Mon, 27 Dec 2010 16:33:01 GMT

Values will be stored anyway. I presume that it's something related to the editor, since you can store anything in a variable.

Regards.

marcohadiyanto — Mon, 27 Dec 2010 16:57:20 GMT

hi,

go to document properties->Variables->new->Variable Name

and then set the value, if you want static then select 'Read-only'