Solved: Re: LEFT WITH TRIM AND IF STATEMENT - Qlik Community

Uri · ‎2020-11-16

Hi!

I have 2 fields: price and phn_num.

In phn_num field I want to display following:

If price is 0 then I want last three digits of phn_num to be replaced with XXX.

BR,

Artur

QFabian · ‎2020-11-16

Hi @Uri !, please try this :

if(price=0, mid(phn_num,1, len(phn_num)-3) & 'XXX', phn_num)

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

QFabian · ‎2020-11-16

Hi @Uri !, please try this :

if(price=0, mid(phn_num,1, len(phn_num)-3) & 'XXX', phn_num)

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

Uri · ‎2020-11-16

It works as expected!

Thank you!

BR,

Artur

LEFT WITH TRIM AND IF STATEMENT