selected fieldvalues into a variable

[#1]

Hi,

i've got a calendar week. For example: 422009, 432009 etc.

When I select 422009 till 452009, i want those values into a variable so I can use them in a set analysis statement.

Can someone help me with this?

Thanks in advance

Rey-man

[#2]

Hi,

What vesion of QlikView are you using? If it is 9 there please check in help for the set analysis. What you are looking for is: element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] ).

Kind regards,

Janusz

[#3]

Hi Janusz,

the version is 8.5, so i need something else.

Rgds,

Rey-man

[#4]

You can use GetFieldSelections(FIELDNAME) to get a comma-delimited list of selected values in FIELDNAME.

Set you variable to:

=GetFieldSelections(FIELDNAME)

[#5]

Hi NMiller,

can I also get al the possible fieldselections(FIELDNAME) to get a comma-delimited list of possible values in FIELDNAME?

Can't find that/

[#6]

No, there is currently no GetPossibleSelections() function. You can use GetPossibleSelected count to get the number of possible selections, but I've never found a need for that. Hopefully, QlikTech has GetPossibleFieldSelections and GetExcludedFieldSelections functions on the to-do list.

If you look at your other topic on the subject, I briefly explained that you need a macro to get the possible selections.

There is also the Concat() function, but I believe that will give you the entire list of field values.

[Oleg_Troyansky]

Concat() is the right answer - it will give you the list of "POSSIBLE" values, with the delimiter of your choice.

[#8]

but, when you select too many values, the return values will be written as NOT value1, valeu2.. etc.. which is bad?