topic Re: How to select only particular values in the field in script editor? in QlikView

How to select only particular values in the field in script editor?

Thu, 19 Mar 2015 08:57:21 GMT

Here is the list box and I need to display only the "F/A" data's other data values shouldn't display. I need to restrict this in script editor. Can somebody help me?

Re: How to select only particular values in the field in script editor?

Thu, 19 Mar 2015 09:01:03 GMT

Hi Murali,

use wildmatch in your script to reduce down your data.

Where wildmatch([Field Name], '*F/A*')

Hope that helps

Joe

Re: How to select only particular values in the field in script editor?

PrashantSangle — Thu, 19 Mar 2015 09:03:02 GMT

Hi,

Try with wildmatch() and special character *

where wildmatch([Field Name], '*F/A*')

Regards

Re: How to select only particular values in the field in script editor?

amit_saini — Thu, 19 Mar 2015 09:07:40 GMT

Hi,

Try this:

Where match(Your_Field,'*F/A*') ;

Thanks,

Re: How to select only particular values in the field in script editor?

hariprasadqv — Thu, 19 Mar 2015 09:12:03 GMT

Use one of the match(wild match is prefered) with where condition.