topic Re: How to find values ending with * in QlikView

How to find values ending with *

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In one field I have values like

Field:

ABC

CDE*

EFG

GHI*

IJK*

KLM

MNO

All the values ending with * means all those records are legacy records.

In the application I have a list box for the Field.

The user would like to search for all value ending with * but just searching for * in list box selects all values.

Re: How to find values ending with *

sunny_talwar — Thu, 05 May 2016 20:50:35 GMT

May be something like this:

LOAD Field,

If(Index(Field, '*') > 0, 1, 0) as Legacy_Flag

FROM Source;

Re: How to find values ending with *

swuehl — Thu, 05 May 2016 20:53:10 GMT

You can also use index() in the search bar of your list box:

=index(Field,'*')

Re: How to find values ending with *

Thu, 05 May 2016 20:54:12 GMT

Hi Sunny,

It needs to be searchable in the front end. I have one list box that has the list of both legacy & non legacy records. In that list anything that ends with a * is legacy. My requirement is, from the list box the user should be able to search all legacy records (basically all values that end with *)

Re: How to find values ending with *

Thu, 05 May 2016 20:57:34 GMT

Awesome. That worked.

I was actually trying the same command index(Field,'*') before posting this question but totally forgot to add the = at the beginning..

Re: How to find values ending with *

Thu, 05 May 2016 21:01:40 GMT

Is there anyway I can apply this as an action to a button?

Re: How to find values ending with *

sunny_talwar — Thu, 05 May 2016 21:13:54 GMT

I think =flag = 1 should be searchable and should be good to use with burron action

Re: How to find values ending with *

swuehl — Thu, 05 May 2016 21:16:20 GMT

Annamalai Muthappan wrote:

Is there anyway I can apply this as an action to a button?

Sure, should be possible using a Selection - Select in field action.

Use field name

Field

and as search string

='=Index(Field,''*'')'

[two single quotes around *, not a single double quote]

Re: How to find values ending with *

sunny_talwar — Thu, 05 May 2016 21:58:37 GMT

Was out when you responded back, have created a sample using the flag method if you want to check it out .