topic Re: Specific Pattern in QlikView

Specific Pattern

Fri, 07 Mar 2014 11:27:04 GMT

Hi Qlik gurus,

I need help with this requirement below.

This test will have a search box with wildcards enabled. The user will have the ability to free type an amount(s) in the search box and the test will return both positive and negative Reporting Amounts ending in the selected sequence(s). For example, if a user were to search for “*.99” this would return reporting amount ending in .99, whether positive or negative.

Thanks in advance

Re: Specific Pattern

tresB — Fri, 07 Mar 2014 11:36:19 GMT

Deafult search does that. May be I did not unserstand it well. Could you post a sample expaining your requirement a bit more?

Re: Specific Pattern

Fri, 07 Mar 2014 11:37:26 GMT

Check this post by HIC, maybe something there that can help you since you can define default string results to be returned

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/16/text-searches

Re: Specific Pattern

maxgro — Fri, 07 Mar 2014 21:42:19 GMT

in a listbox with "Use Wildcard Search" as "Default Search Mode", just type

,91

and press Enter to select positive and negative

other example with only 2 decimal as your requirement