topic Re: Where IN with qlikview in QlikView

Where IN with qlikview

souadouert — Thu, 16 Nov 2017 12:28:08 GMT

Region_Zone:

LOAD Code as Code,

upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE,

'région' as type_entite

FROM

(ooxml, embedded labels, table is Feuil1);

Zone:

LOAD Code as Code,

UPPER(Zone) as ENTITE,

'zone' as type_entite

FROM

(ooxml, embedded labels, table is Feuil2);

REF:

LOAD ID ,

AREA,

NAME,

DEPT_LEVEL,

DEPT_PARENT

FROM

(ooxml, embedded labels, table is Feuil1);

so i need to add thius clause ->> where NAME in (select ENTITE from region_zone )

Re: Where IN with qlikview

sunny_talwar — Thu, 16 Nov 2017 12:30:07 GMT

May be try this

Region_Zone:

LOAD Code as Code,

upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE,

upper(Replace(Région,'Région','DIRECTION REGIONALE')) AS ENTITE_Check

'région' as type_entite

FROM

(ooxml, embedded labels, table is Feuil1);

Zone:

LOAD Code as Code,

UPPER(Zone) as ENTITE,

'zone' as type_entite

FROM

(ooxml, embedded labels, table is Feuil2);

REF:

LOAD ID ,

AREA,

NAME,

DEPT_LEVEL,

DEPT_PARENT

FROM

(ooxml, embedded labels, table is Feuil1)

Where Exists(ENTITE_Check, NAME);

Re: Where IN with qlikview

PrashantSangle — Thu, 16 Nov 2017 12:32:24 GMT

Hi,

use where exists()

REF:

LOAD ID ,

AREA,

NAME,

DEPT_LEVEL,

DEPT_PARENT

FROM

(ooxml, embedded labels, table is Feuil1)

where exists(ENTITE,NAME)

;

Re: Where IN with qlikview

souadouert — Thu, 16 Nov 2017 12:34:57 GMT

Thank you sunny

Re: Where IN with qlikview

sunny_talwar — Thu, 16 Nov 2017 12:35:00 GMT

But dreamer4‌ this would check for NAME against both Region_Zone table and Zone table... Not sure if this is what souadouert‌ wants

Re: Where IN with qlikview

souadouert — Thu, 16 Nov 2017 12:35:19 GMT

thank you

Re: Where IN with qlikview

PrashantSangle — Thu, 16 Nov 2017 12:38:09 GMT

Actually I did not gone through her entire script.

I just gave her logic and function which she is looking for.

Regards,