Filter help???

[amit_saini]

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

[amit_saini]

Same Result.

[elyM]

Hi Amit,

you can apply this rule in QlikView Script - backend or is stricly necessary frontend ?

Regards,

Ely

[jonathandienst · Accepted solution]

I assume you need a wildmatch...

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

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