Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

philgood34
Contributor II

FILTER IN LOADING SCRIPT WHERE EXISTS ?

Hi

i try to select datas during the loading script and i read several threads about "Where exists" (qlik view) but i don't no if it's possible with qlik sense and how

here is my issue :

tab 1

NCL     LIB

A         SECTOR 1

B          SECTOR 2

C          SECTOR 3

tab 2

tab2_NCL      SALES

A                    12

B                    24

C                    10

D                    36

E ....     ....

tab 3

tab3_NCL      margin

A                    5

B                    8

C                    8

D                    15

E ...     ...

in summary my script is :

tab1

load ncl as ncl-tab2_ncl,

load lib

FROM [lib://file.xls]

(biff, embedded labels, table is tab1);

tab2

load tab2_ncl as ncl-tab2_ncl,

load sales

FROM [lib://file.xls]

(biff, embedded labels, table is tab2);


tab3

load tab3_ncl as ncl-tab2_ncl,

load margin

FROM [lib://file.xls]

(biff, embedded labels, table is tab3);


What and where should I insert 

to load only A,B & C DATAS from the tab 2 & 3 ?

Thank's in advance

Philippe

1 Solution

Accepted Solutions
MVP
MVP

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

Maybe

tab1:

load

ncl as ncl-tab2_ncl,

lib

FROM [lib://file.xls]

(biff, embedded labels, table is tab1);

tab2:

load

tab2_ncl as ncl-tab2_ncl,

sales

FROM [lib://file.xls]

(biff, embedded labels, table is tab2)

WHERE EXISTS(ncl-tab2_ncl, tab2_ncl) ;


tab3:

load

tab3_ncl as ncl-tab2_ncl,

margin

FROM [lib://file.xls]

(biff, embedded labels, table is tab3)

WHERE EXISTS(ncl-tab2_ncl, tab3_ncl);

3 Replies
MVP
MVP

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

Maybe

tab1:

load

ncl as ncl-tab2_ncl,

lib

FROM [lib://file.xls]

(biff, embedded labels, table is tab1);

tab2:

load

tab2_ncl as ncl-tab2_ncl,

sales

FROM [lib://file.xls]

(biff, embedded labels, table is tab2)

WHERE EXISTS(ncl-tab2_ncl, tab2_ncl) ;


tab3:

load

tab3_ncl as ncl-tab2_ncl,

margin

FROM [lib://file.xls]

(biff, embedded labels, table is tab3)

WHERE EXISTS(ncl-tab2_ncl, tab3_ncl);

philgood34
Contributor II

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

DATAS LOADED !

i'll test my vizualisations tomorrow and tell you

thank's

Philippe

philgood34
Contributor II

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

it's perfect !

very helpful for my data model

thank's a lot !

Community Browser