topic search for values of a field on activate sheet in QlikView

search for values of a field on activate sheet

ali_hijazi — Tue, 05 Aug 2014 08:42:24 GMT

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

Re: search for values of a field on activate sheet

tresB — Tue, 05 Aug 2014 08:54:29 GMT

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 , '|' )

& ')'

Re: search for values of a field on activate sheet

ali_hijazi — Tue, 05 Aug 2014 08:57:40 GMT

didn't work

are we missing something here (syntax error?)

Re: search for values of a field on activate sheet

tresB — Tue, 05 Aug 2014 09:01:03 GMT

Could you post your sample qvw?

Re: search for values of a field on activate sheet

ali_hijazi — Tue, 05 Aug 2014 09:08:50 GMT

check attached sample

Re: search for values of a field on activate sheet

tresB — Tue, 05 Aug 2014 09:49:07 GMT

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

Re: search for values of a field on activate sheet

tresB — Tue, 05 Aug 2014 10:04:34 GMT

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.