Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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
Master II
Master II

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
Partner

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

View solution in original post

iswarya
Partner
Partner

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

View solution in original post

saik
Contributor II
Contributor II
Author

Thank you.