Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

Where IN with qlikview

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 )

6 Replies

Re: Where IN with qlikview

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

Hi,

use where exists()

REF:

LOAD ID ,

     AREA,

    NAME,

     DEPT_LEVEL,

     DEPT_PARENT   

FROM

(ooxml, embedded labels, table is Feuil1)

where exists(ENTITE,NAME)

;

Regards,
Prashant Sangle
souadouert
Contributor III

Re: Where IN with qlikview

Thank you sunny    

Re: Where IN with qlikview

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

souadouert
Contributor III

Re: Where IN with qlikview

thank you

Re: Where IN with qlikview

Actually I did not gone through her entire script.

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

Regards,

Regards,
Prashant Sangle
Community Browser