Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to do a Wildmatch for more than 100 lines?

Hi All,

I am sitting with a problem. I need to do a WildMatch for 3000 lines of data... But the WildMatch function only allows 100 lines?

Please does anyone have a way to get around this problem or maybe another function that i can use?

Added an Example with notes in the Script

Stefan

4 Replies
Not applicable

Re: How to do a Wildmatch for more than 100 lines?

Hi Stefan,

If I may ask, why are you wildmatching that many values? Would it not be better to load an excel or .txt file with the value you are widmatching to and then use applymap() to get the desired result.

Having that many wildmatches is going to be a maintenance nightmare

Cheers,

Byron

Highlighted

Re: How to do a Wildmatch for more than 100 lines?

This item on using wildcards with ApplyMap may help

http://community.qlik.com/message/188830#188830

Not applicable

Re: How to do a Wildmatch for more than 100 lines?

I agree with Byron

What do you want to do ? Just wildmatch because you love that function ?? Or sth for your user ?

Tell us what you wanted to achieve before thinking to wildmatch: there is perhaps sth simple...

Fabrice

Not applicable

Re: How to do a Wildmatch for more than 100 lines?

Hi Byron,

Please see my attachment. My notes are in the script

Community Browser