topic Re: Get Field Selection Function in Connectivity & Data Prep

Get Field Selection Function

dunnalahk123 — Fri, 02 Apr 2021 08:01:20 GMT

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 — Fri, 07 Apr 2017 09:59:53 GMT

Provide some more information...

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

Anonymous — Fri, 07 Apr 2017 10:00:26 GMT

Could you provide sample data please?

dunnalahk123 — Fri, 07 Apr 2017 10:38:48 GMT

I have added QVW as attachemnt.

Thank You.

jpar0511 — Fri, 07 Apr 2017 10:53:11 GMT

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 — Fri, 07 Apr 2017 11:11:37 GMT

Thank You So Much. Got You 🙂