Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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.
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.
and here i thought it'd be more complicated than that.
cheers.