topic Re: Multiple Condition in QlikView

Multiple Condition

Karim_Khan — Mon, 24 Aug 2015 11:26:32 GMT

HI Team,

I have the two Sales Level 1 and Sales Level 2.

In Sales Level 1 I have Field EMEAR-REGION which is mapped to Sales Level 2 value i.e

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - EMERGING

EMEAR - NORTH

EMEAR - UK

EMEAR - OTHER

But in above Field If I select EMAR-REGION then it should directly associate to EMEAR - EMERGING

and I want to create one more Field with name EUROPE in Sales Level 2 which should directly pick the remaining 4 fields for category IOT.

If I Select category IOT then it should pick the remaining 4 Value

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - NORTH

EMEAR - UK

And If I Select category IOE then it should pick the remaining 5 Value.

EMEAR - CENTRAL

EMEAR - SOUTH

EMEAR - NORTH

EMEAR - UK

EMEAR - OTHER

Regards,

KK !

Re: Multiple Condition

Karim_Khan — Mon, 24 Aug 2015 11:30:07 GMT

I am trying to achieve the above requirment by belwo script

Cisco:

LOAD [End Customer Global Ultimate Name],

Country,

[End Customer HQ Top],

[Sales Level 3],

[Sales Level 4],

[Sales Level 5],

[Partner Name],

[Fiscal Period ID] as Fiscalid,

[Net Bookings],

CATEGORY ,

If([Sales Level 2]='EMEAR-EMERGING','EMEAR-REGION' ,

If(Match([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI') AND MATCH([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI','EMEA OTHER'),'EUROPE',[Sales Level 1])) as [Sales Level 1],

[Sales Level 2]

FROM

But its satisfying 1 requirement taking 4 values not other requirement

Reagrds,

Re: Multiple Condition

jonathandienst — Mon, 24 Aug 2015 11:33:38 GMT

You could load it much like this. Just convert from the inline to an XLS load:

LOAD SalesLevel1,

If(SalesLevel2 = 'Emerging', 'Emerging', 'Europe') As SalesLevel2,

SalesLevel2 As SalesLevel3

Inline

[

SalesLevel1, SalesLevel2

EMEAR,CENTRAL

EMEAR,SOUTH

EMEAR,EMERGING

EMEAR,NORTH

EMEAR,UK

EMEAR,OTHER

];

Re: Multiple Condition

gautik92 — Mon, 24 Aug 2015 11:35:38 GMT

IOT Map

Mapping Load

EMAR-REGION,

if(Match(EMEAR-REGION,'EMEAR - CENTRAL','EMEAR - SOUTH','EMEAR - NORTH','EMEAR - UK')>0,1,0) as IOTMapping

from

use it in ApplyMap

IOEMap:

Mapping Load

EMAR-REGION,

if(Match(EMAR-REGION,'EMEAR - CENTRAL','EMEAR - SOUTH','EMEAR - NORTH','EMEAR - UK','EMEAR - OTHER')>0,1,0) as IOEMapping

from

Re: Multiple Condition

Karim_Khan — Mon, 24 Aug 2015 11:37:42 GMT

we can't use where clause?

Re: Multiple Condition

jonathandienst — Mon, 24 Aug 2015 11:49:25 GMT

Did you try my suggestion?

Re: Multiple Condition

sasiparupudi1 — Mon, 24 Aug 2015 12:03:41 GMT

If(Match([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI') OR MATCH([Sales Level 2],'EMEAR-CENTRAL','EMEAR-SOUTH','EMEAR-NORTH','EMEAR-UKI','EMEA OTHER'),'EUROPE',[Sales Level 1])) as [Sales Level 1],

Re: Multiple Condition

Mon, 24 Aug 2015 12:11:21 GMT

Hi,

PFA,

May be it wil match with your req.

Re: Multiple Condition

Karim_Khan — Mon, 24 Aug 2015 12:28:33 GMT

Tnx a lot sir

Re: Multiple Condition

Karim_Khan — Mon, 24 Aug 2015 12:29:26 GMT

s I have applied both suggestion and both are working