topic Filter help??? in QlikView

Filter help???

amit_saini — Thu, 10 Sep 2015 10:57:32 GMT

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,

Re: Filter help???

qlikmsg4u — Thu, 10 Sep 2015 11:00:52 GMT

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

Re: Filter help???

amit_saini — Thu, 10 Sep 2015 11:15:44 GMT

K N,

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

Thanks,
AS

Re: Filter help???

qlikmsg4u — Thu, 10 Sep 2015 11:17:12 GMT

Amit

try this

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

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

Re: Filter help???

amit_saini — Thu, 10 Sep 2015 11:23:25 GMT

Sorry same result!

Re: Filter help???

qlikmsg4u — Thu, 10 Sep 2015 11:25:37 GMT

Can you share the sample app?

Re: Filter help???

PrashantSangle — Thu, 10 Sep 2015 11:32:20 GMT

Hi,

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

Regards

Re: Filter help???

amit_saini — Thu, 10 Sep 2015 11:32:46 GMT

Sorry not possible , but i can share this:

Thanks,

Re: Filter help???

qlikmsg4u — Thu, 10 Sep 2015 11:33:14 GMT

Replace % with *

Re: Filter help???

amit_saini — Thu, 10 Sep 2015 11:35:10 GMT

Re: Filter help???

amit_saini — Thu, 10 Sep 2015 11:35:28 GMT

Same Result.

Re: Filter help???

elyM — Thu, 10 Sep 2015 11:38:41 GMT

Hi Amit,

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

Regards,

Ely

Re: Filter help???

jonathandienst — Thu, 10 Sep 2015 11:55:51 GMT

I assume you need a wildmatch...

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

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