Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 :
A SECTOR 1
B SECTOR 2
C SECTOR 3
E .... ....
E ... ...
in summary my script is :
load ncl as ncl-tab2_ncl,
(biff, embedded labels, table is tab1);
load tab2_ncl as ncl-tab2_ncl,
(biff, embedded labels, table is tab2);
load tab3_ncl as ncl-tab2_ncl,
(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
Go to Solution.
ncl as ncl-tab2_ncl,
tab2_ncl as ncl-tab2_ncl,
(biff, embedded labels, table is tab2)
WHERE EXISTS(ncl-tab2_ncl, tab2_ncl) ;
tab3_ncl as ncl-tab2_ncl,
(biff, embedded labels, table is tab3)
WHERE EXISTS(ncl-tab2_ncl, tab3_ncl);
DATAS LOADED !
i'll test my vizualisations tomorrow and tell you
it's perfect !
very helpful for my data model
thank's a lot !