topic Re: FILTER IN LOADING SCRIPT WHERE EXISTS ? in App Development

FILTER IN LOADING SCRIPT WHERE EXISTS ?

philgood34 — Mon, 02 Oct 2017 16:10:13 GMT

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

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

swuehl — Mon, 02 Oct 2017 16:24:04 GMT

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);

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

philgood34 — Mon, 02 Oct 2017 17:24:55 GMT

DATAS LOADED !

i'll test my vizualisations tomorrow and tell you

thank's

Philippe

Re: FILTER IN LOADING SCRIPT WHERE EXISTS ?

philgood34 — Tue, 03 Oct 2017 07:28:28 GMT

it's perfect !

very helpful for my data model

thank's a lot !