topic Re: getfieldselections() in set analysis, more than 5 selected searching for 6 of xxx in App Development

getfieldselections() in set analysis, more than 5 selected searching for 6 of xxx

jasonrimkus — Thu, 10 Mar 2022 19:44:49 GMT

I'm using getfieldselections() in set analysis as described in this post (which works great!)

https://community.qlik.com/t5/QlikView-App-Dev/GetFieldSelections-with-set-analysis/td-p/412614

HOWEVER, i'm using it in a Have/HaveNot fashion and if the user selects more than 5 in the have, the variable goes from listing out the selections in the variable to what's shown in the selection box (6 of xxx).

SET EXPRESSION: ...

Account.accountid =
E({<Order.Service = {"$(vSoldHaveNot)"} ...

variable:

vSoldHaveNot =Replace(GetFieldSelections(SoldExcluded),', ','","')

So rather than something like this:

"1 / Service 1","2 / Service 2","3 / Service 3...."

after selecting more than 5, its searching for:

"6 of 298"

Re: getfieldselections() in set analysis, more than 5 selected searching for 6 of xxx

Or — Thu, 10 Mar 2022 19:46:24 GMT

As per the GetFieldSelections() documentation:

GetFieldSelections ( field_name [, value_sep [, max_values [, state_name]]])

Emphasis added. Six is indeed the default, but you can pick your own number.

Re: getfieldselections() in set analysis, more than 5 selected searching for 6 of xxx

jasonrimkus — Thu, 10 Mar 2022 20:16:41 GMT

and here i thought it'd be more complicated than that.

cheers.