topic Re: Wildmatch function in if condition in QlikView

Wildmatch function in if condition

canmarroig — Fri, 25 Mar 2016 10:09:29 GMT

I've to create a list box, changing text into number: if(WildMatch([code_nr],'PRB*'),'00',[code_nr])

i'd like to clean: PRB09090900 into 0009090900. Where's my mistake?

Tks

sunny_talwar — Fri, 25 Mar 2016 10:11:49 GMT

May be this:

Num(Replace(code_nr, 'PBR', '00'), '##')

Num#(Replace(code_nr, 'PBR', '00'), '##')

tresB — Fri, 25 Mar 2016 10:13:33 GMT

Try like:

Replace([code_nr],'PRB','00')

Kushal_Chawda — Fri, 25 Mar 2016 10:44:23 GMT

Another way

00 & purgechar([code_nr],'PRB')

canmarroig — Fri, 25 Mar 2016 10:49:47 GMT

This function change my field but add 00 before every occurrency in my dimension

canmarroig — Fri, 25 Mar 2016 10:50:11 GMT

Tks!!

canmarroig — Fri, 25 Mar 2016 11:03:10 GMT

and if I need to change all my string, cointaining a prefix, not only a part of it

PRB09090900

PRB08776766

into 00

Num#(Replace(code_nr, 'PBR*', '00'), '##') is not correct

sunny_talwar — Fri, 25 Mar 2016 11:04:49 GMT

Then I would use WildMatch()

If(WildMatch(code_nr, 'PBR*'), '00', code_nr)