hello ,i have a request tab1 had all teams i want to exclure the CD_Equipe mentionned in the excel file .
![excel.PNG excel.PNG](https://community.qlik.com/t5/image/serverpage/image-id/110782i2A4EAE5A1468786A/image-size/large?v=v2&px=999)
tab1:
NoConcatenate
select
DT_EVENEMENT,
Nom_EQUIPE,
CD_EQUIPE,
sum(sales) AS vente
from
tab1 , tab2
where
group by
DT_EVENEMENT,
Nom_EQUIPE,
CD_EQUIPE ;
exclusion:
LOAD
CD_EQUIPE,
DT_DEBUT,
DT_FIN
//LIB_EQUIPE_COURT
FROM [lib://AttachedFiles/exclu.xlsx]
(ooxml, embedded labels, table is [Exclusion Equipes]);
exclusion2:
NoConcatenate
Load
*
resident tab1;
inner join
IntervalMatch(DT_EVENEMENT,CD_EQUIPE)
load DT_DEBUT , DT_FIN , CD_EQUIPE
resident exclusion;
exclusion3:
NoConcatenate
load *
resident exclusion2
where isnull(DT_DEBUT);
i wrote this code but it doesn't function the 0555, 0556 ,0888 still here !!!
can someone help me 😞