Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Get Field Selection Function

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

1 Solution

Accepted Solutions
jpar0511
Contributor III
Contributor III

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

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Provide some more information...

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

sitrakiniaina_j
Creator II
Creator II

Could you provide sample data please?

dunnalahk123
Creator III
Creator III
Author

I have added QVW as attachemnt.

Thank You.

jpar0511
Contributor III
Contributor III

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
Creator III
Creator III
Author

Thank You So Much. Got You  🙂