topic selected fieldvalues into a variable in QlikView

selected fieldvalues into a variable

Mon, 02 Nov 2009 23:09:34 GMT

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

selected fieldvalues into a variable

Mon, 02 Nov 2009 23:28:19 GMT

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

selected fieldvalues into a variable

Mon, 02 Nov 2009 23:30:35 GMT

Hi Janusz,

the version is 8.5, so i need something else.

Rgds,

Rey-man

selected fieldvalues into a variable

Mon, 02 Nov 2009 23:56:08 GMT

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

Set you variable to:

=GetFieldSelections(FIELDNAME)

selected fieldvalues into a variable

Tue, 03 Nov 2009 00:06:02 GMT

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/

selected fieldvalues into a variable

Tue, 03 Nov 2009 00:19:05 GMT

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.

selected fieldvalues into a variable

Oleg_Troyansky — Tue, 03 Nov 2009 01:40:17 GMT

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

Re: selected fieldvalues into a variable

Thu, 27 Sep 2012 12:52:33 GMT

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