topic Re: Wildmatch in Select in Field Trigger in QlikView

Wildmatch in Select in Field Trigger

riyazasma1009 — Wed, 26 Apr 2017 12:49:42 GMT

Hi,

I have a field 'Test' which contains values such as below:

Test

Test is- A

abcd

Test is - B

Test is- C

Test is- D

No Test

Test is- E

Test is- F

Test is- G

Test is- H

Test is- I

dfghk

fghhjuy

uioyy

hjkjh

iuyt

asdf

On the dashboard, I always want that the values starting with Test is -* should be selected.

Can someone please help me on this.

Thanks,

Asma

Re: Wildmatch in Select in Field Trigger

sunny_talwar — Wed, 26 Apr 2017 12:56:36 GMT

May be try Select in field action like this

Field

Test

Search String

='("' & Concat(DISTINCT {<Test = {'Test is -*'}>} Test, '"|"') & '")'

='("' & Concat(DISTINCT {<Test = {'Test is*'}>} Test, '"|"') & '")'

Re: Wildmatch in Select in Field Trigger

riyazasma1009 — Wed, 26 Apr 2017 13:06:13 GMT

Hi Sunny,

Thanks for the quick reply. Adding the above expression in the search string for Select in Field Trigger works fine. But the values which do not fall under this criteria are not shown in the list box. I want that the non matching values should be greyed out.

Re: Wildmatch in Select in Field Trigger

sunny_talwar — Wed, 26 Apr 2017 13:13:14 GMT

Are you using a calculated expression for your list box? If you are, then what is the expression?

Re: Wildmatch in Select in Field Trigger

riyazasma1009 — Wed, 26 Apr 2017 13:20:29 GMT

No, it is just a simple list box containing the field Test

Re: Wildmatch in Select in Field Trigger

sunny_talwar — Wed, 26 Apr 2017 13:41:06 GMT

I don't see any problem....

Re: Wildmatch in Select in Field Trigger

riyazasma1009 — Thu, 27 Apr 2017 12:25:20 GMT

Thanks Sunny for the reply! The expression is working as expected. There was something wrong at my end