Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Mark/Flag a field if contains certain chain characters

Hello All,
I want to mark with a flag if my field "DESC" contain one or more of the  next words:

PALABRA
PRE CORTADA
PRECORTADA
CORTE
DESPERDICIO
SALDO
FALLA
DEFECT
REPARA
RETRABAJO
RE TRABAJO
COMPOSTURA
PARTE

 

For this im trying to set the next "IF" function:

if("DESC"='%PRE CORTADA%' or "DESC"='%PRECORTADA%' or "DESC"='%CORTE%' or "DESC"='%DESPERDICIO%' or "DESC"='%SALDO%' or "DESC"='%FALLA%'
or "DESC"='%DEFECT%' or "DESC"='%REPARA%' or "DESC"='%RETRABAJO%' or "DESC"='%RE TRABAJO%' or "DESC"='%COMPOSTURA%' or "DESC"='%PARTE%',1,0
) as Recorte

But this is not working 😞
Did someone already did something like this before? 
I would appreciate a lot if someone could help me with this.
Regards.

 

JAAM.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

the operator you want is "like". And you probably want to use "*" as the wildcard. So...

"DESC" like '*PRE CORTADA*'

-Rob

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

the operator you want is "like". And you probably want to use "*" as the wildcard. So...

"DESC" like '*PRE CORTADA*'

-Rob

View solution in original post

Partner
Partner

Thanks for your help Rob, it works too good.

Regards.