Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
amit_saini
Honored Contributor 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
MVP
MVP

Re: Filter help???

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
12 Replies
qlikmsg4u
Valued Contributor

Re: Filter help???

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

amit_saini
Honored Contributor III

Re: Filter help???

K N,

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

Thanks,
AS

qlikmsg4u
Valued Contributor

Re: Filter help???

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
Honored Contributor III

Re: Filter help???

Sorry same result!

qlikmsg4u
Valued Contributor

Re: Filter help???

Can you share the sample app?

Re: Filter help???

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
amit_saini
Honored Contributor III

Re: Filter help???

Sorry not possible , but i can share this:

Thanks,

AS

qlikmsg4u
Valued Contributor

Re: Filter help???

Replace % with *

amit_saini
Honored Contributor III

Re: Filter help???

Community Browser