topic Help Needed in App Development

Help Needed

saik — Sat, 16 Nov 2024 03:25:28 GMT

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.

Re: Help Needed

Taoufiq_Zarra — Wed, 29 Jan 2020 15:13:11 GMT

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

Re: Help Needed

iswarya — Wed, 29 Jan 2020 15:18:20 GMT

Hi Saik,

You can use the wildmatch function

Re: Help Needed

Kushal_Chawda — Wed, 29 Jan 2020 15:21:15 GMT

How you want to represent those values?

Re: Help Needed

saik — Wed, 29 Jan 2020 15:34:23 GMT

Hi,

Thanks for replying

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

Regards,

Sai

Re: Help Needed

iswarya — Wed, 29 Jan 2020 16:01:12 GMT

You can try like this:

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

Re: Help Needed

Kushal_Chawda — Wed, 29 Jan 2020 16:04:37 GMT

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

Re: Help Needed

saik — Wed, 29 Jan 2020 16:13:51 GMT

Thank you.