Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

canmarroig
New Contributor III

Wildmatch function in if condition

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

Tags (1)
1 Solution

Accepted Solutions

Re: Wildmatch function in if condition

May be this:

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


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

7 Replies

Re: Wildmatch function in if condition

May be this:

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


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

MVP
MVP

Re: Wildmatch function in if condition

Try like:

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

Re: Wildmatch function in if condition

Another way

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

canmarroig
New Contributor III

Re: Wildmatch function in if condition

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

canmarroig
New Contributor III

Re: Wildmatch function in if condition

Tks!!

canmarroig
New Contributor III

Re: Wildmatch function in if condition

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


Re: Wildmatch function in if condition

Then I would use WildMatch()

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

Community Browser