Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.