Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jasonrimkus
Contributor II
Contributor II

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

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"

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

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.

View solution in original post

2 Replies
Or
MVP
MVP

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.

jasonrimkus
Contributor II
Contributor II
Author

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

 

cheers.