Get Field Selection Function

[dunnalahk123]

Hi,

I am Writing simple Get Field Selection as below for my Geography Fields.

For 3 Fields it working as expected but one of the geography fields it is taking as per below

=GetFieldSelections(Subregion2)

Gives me value 7 of 36 instead USA, Brazil etc. can any one have any idea y its behaving like this.

Best Regards,

Message was edited by: HariKiran Dunnala

[MK_QSL]

Provide some more information...

May be sample data or sample app would be more useful to work.

[Anonymous]

Could you provide sample data please?

[dunnalahk123]

I have added QVW as attachemnt.

Thank You.

[jpar0511 · Accepted solution]

The problem is that in standard Qlikview is showing a maximum of 6 Values in a text-box.

You can get this higher using the following paramenter:

= '"' & Replace ( GetFieldSelections(Subregion2,',',10), ', ' , '","' ) & '"'

You might need to adjust the behaviour of "".

Here are the paramenters for GetFieldSelections:

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

--> MaxValues identifies how many are shown if you need more than the standard 6

[dunnalahk123]

Thank You So Much. Got You  🙂