topic GetFieldSelections() problem in QlikView

GetFieldSelections() problem

teempi — Tue, 23 Jun 2009 19:57:34 GMT

Hello,

I have a calendar component that lets users choose years, months and days to analyze. I'm using a set analysis statement that forces the calculations to use the same date information (day, month, year) as selected elsewhere in a few expressions. I've made variables that have values (in short) GetFieldSelections(Year), GetFieldSelections(Month), GetFieldSelections(Day). I use those variables in the set analysis statements.

If I select days 1, 2 and 3 for example, everything works like it's supposed to. If I increase the amount of selections to 1,2,3,4,5,6,7, the current selections box displays my selections like this: (7 of 31). At the same time my expressions stop working and nothing is printed. GetSelectedCount() returns 7 like it's supposed to but for some reason the GetFieldSelections() -function won't return any selections. Or it might return something but definately not the ones I've selected.

Any tips?

GetFieldSelections() problem

Tue, 23 Jun 2009 20:05:12 GMT

Hi,

what are QV HELP is saying: Look for MaxValues ...

Maybe the only thing you need is to increase the number for MaxValues.

getfieldselections ( FieldName [, ValueSep [, MaxValues]] )

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '.

Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

Rainer

GetFieldSelections() problem

Tue, 23 Jun 2009 20:10:14 GMT

The default is 6:

GetFieldSelections (field_name [, value_sep [, max_values=6]])

Regards,

Gordon

GetFieldSelections() problem

teempi — Tue, 23 Jun 2009 20:10:19 GMT

That did the trick, thank you so much! Now I feel ashamed for not figuring that out myself 🙂

GetFieldSelections() problem

Tue, 23 Jun 2009 20:17:25 GMT

It doesn´t matter.

That´s one of the reasons the community is good for:

Helping out each other ...

Rainer