Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saik
Contributor II
Contributor II

Help Needed

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.

 

Labels (1)
2 Solutions

Accepted Solutions
saik
Contributor II
Contributor II
Author

Hi,

Thanks for replying

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

Regards,

Sai

View solution in original post

Kushal_Chawda

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

View solution in original post

7 Replies
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
];

 

Capture.JPG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
iswarya
Partner - Creator
Partner - Creator

Hi Saik,

You can use the wildmatch function 

Kushal_Chawda

How you want to represent those values?

saik
Contributor II
Contributor II
Author

Hi,

Thanks for replying

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

Regards,

Sai

iswarya
Partner - Creator
Partner - Creator

You can try like this:

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

Kushal_Chawda

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
Contributor II
Contributor II
Author

Thank you.