topic Filter values based on Prefix in QlikView

Filter values based on Prefix

Aara — Mon, 02 May 2022 06:49:57 GMT

I have a Input Box and a Straight table. If I search with a prefix of a value in Input Box , straight table should return all the values with the prefix. For example, If I search with a Prefix as CRO in description column and click on Apply Filter button, it should return all the description starting with CRO.

Re: Filter values based on Prefix

vchuprina — Mon, 02 May 2022 08:55:06 GMT

Hi,

You can add a search object instead of an input box and apply the filter button

Add a list of fields for search

Also, you can change the style on the presentation tab

Regards,

Vitalii

Re: Filter values based on Prefix

Akeem — Thu, 05 May 2022 05:07:36 GMT

@Aara wrote:

I have a Input Box and a Straight table. If I search with a prefix of a value in Input Box , straight table should return all the values with the prefix. For example, If I search with a Prefix as CRO in description column and click on Apply Filter button, it should return all the description starting with CRO.

HP Instant Ink Plans

I was trying this out and got some issues and still finding it can you give some more suggestions if any thanks in advance.

Re: Filter values based on Prefix

Marijn — Mon, 02 May 2022 12:13:05 GMT

Hi Aari,

You can also use a List Box. By setting Default Search Mode to Use Wildcard search, two * will be added to your search string. This means that if you search for CRO, it will look like *CRO*. The results will include all strings that contain CRO.

Additionally, you can also search for CRO*, which will return every string that starts with CRO.

Hope this helps!

Marijn

Re: Filter values based on Prefix

Aara — Tue, 03 May 2022 12:37:12 GMT

Adding to my requirement, reason for Input box is, user should have options to filter multiple values for the particular column. Example, when user wanted to search with State that starts with, "CA" , "NO" in a comma separated value search, it should display all the State that begins with "CA" and "NO".