Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
DATAS LOADED !
i'll test my vizualisations tomorrow and tell you
thank's
Philippe
it's perfect !
very helpful for my data model
thank's a lot !