search for values of a field on activate sheet

[ali_hijazi]

Hello

got a field in my data called DEV_PLAN_KEY

in the list box I can put the following search string to select the desired values

=count({<DATA_SOURCE={'CRM'}>+ <DATA_SOURCE={'CRM_AUDIT'},LAST_FLG={1}>} DISTINCT STATUS)>1

what is the syntax to make the above selection upon activating the sheet

I've put the same search string in the select in field action under value of the above field but the values are not being selected

please advise

Message was edited by: Ali Hijazi

[tresesco]

Try this search string:

='(' &

Concat( Distinct {<DEV_PLAN_KEY={"=count({<DATA_SOURCE={'CRM'}>+ <DATA_SOURCE={'CRM_AUDIT'},LAST_FLG={1}>} DISTINCT STATUS)>1 "} > } DEV_PLAN_KEY , '|' )

& ')'

[ali_hijazi]

didn't work

are we missing something here (syntax error?)

[tresesco]

Could you post your sample qvw?

[ali_hijazi]

check attached sample

[tresesco]

I did not notice this earlier. QV is not concatenating string after certain number of items. For your sample application I found that qv can concat upto 6553 values (I tested with DEFECT_ID field). I would suggest to log a call with qlik. Or, may be someone can confirm if there is any such documentation about this limitation.

Tested env: QV11.2 SR6

[tresesco]

Further analysis shows that it has limitation in lenght rather than number of items. It's :

2^16 -1 = 65535

So QV can concatenate string upto length 65535.

Request qlik's opinion.