Help Needed

[saik]

Hi team,

I need some help related to functions. Please go through below  Scenario

Scenario:

 I have  Field (Eating Status) which is having  Like    "  I  Completed the Dinner at  9 PM Today " ,  "  I  Completed the lunch at  1 PM Today " ,"  I  Completed the Breakfast at  10 AM Today ".  I need to get the  Values which is Having  " Dinner" . 

 Which function  i have to use to get the same.  Thanks in Advance.

 Note : I am a Novice user  to Qlik Sense.

Regards,

Sai.

[Taoufiq_Zarra]

maye be :

load if(wildmatch([Eating Status],'*Dinner*')>0,'OK','KO') as DinnerStatus,* inline [
Eating Status
I  Completed the Dinner at  9 PM Today
I  Completed the lunch at  1 PM Today
I  Completed the Breakfast at  10 AM Today
];

[iswarya]

Hi Saik,

You can use the wildmatch function 

[Kushal_Chawda]

How you want to represent those values?

[saik · Accepted solution]

Hi,

Thanks for replying

I have to create a calculated field  if  filed  contains  "dinner"  have to return Dinner else NA.

Regards,

Sai

[iswarya]

You can try like this:

if(WildMatch([Eating Status],'*Dinner*'),'Dinner','NA') as FieldName

[Kushal_Chawda · Accepted solution]

It's not always necessary that your dinner value have in same case (upper,lower,capitalize), so instead use lower function to convert all string values to lower and then use wildcard.

if(WildMatch(lower([Eating Status]),'*dinner*'),'Dinner','NA') as FieldName

[saik]

Thank you.