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: 
amit_saini
Master III
Master III

Filter help???

Hi Folks,

Below is my requirement :

I would like to implement the following logic (I want to use Category 2 for the split and leave Category 3 reporting the existing data)

Where category 3 is like BEL% then set category 2 = Incident

Where category 3 is null then set category 2 = Unclassified

  Else set category 2 = Change


I'm trying something like this : 

=if(match(Category3,'_BEL%'),'Incident',

if(match(Category3,'-'),'Unclassified','Change'))

But it's not working. Kindly help!

Thanks,

AS


1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

I assume you need a wildmatch...

=if(wildmatch(Category3, '*_BEL*'), 'Incident',

  if(IsNull(Category3) or Category3 = '-', 'Unclassified', 'Change'))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

12 Replies
qlikmsg4u
Specialist
Specialist

=if(match(Category3,'_BEL%'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))

amit_saini
Master III
Master III
Author

K N,

In my case and in ur suggestion still I'm having issue:

Thanks,
AS

qlikmsg4u
Specialist
Specialist

Amit

try this

=if(match(Category3,'%_BEL'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))


or


=if(match(Category3,'*_BEL'),'Incident',if(IsNull(Category3) or Category3 = '-','Unclassified','Change'))

amit_saini
Master III
Master III
Author

Sorry same result!

qlikmsg4u
Specialist
Specialist

Can you share the sample app?

PrashantSangle

Hi,

You have to use * as wildcard search not % try with *

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
amit_saini
Master III
Master III
Author

Sorry not possible , but i can share this:

Thanks,

AS

qlikmsg4u
Specialist
Specialist

Replace % with *

amit_saini
Master III
Master III
Author