3 Replies Latest reply: Oct 3, 2017 3:28 AM by Philippe BONNIN RSS

    FILTER IN LOADING SCRIPT WHERE EXISTS ?

    Philippe BONNIN

      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