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

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

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

1 Solution

Accepted Solutions

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.

View solution in original post

2 Replies

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.

Author

It works as expected!

Thank you!

BR,

Artur