Hi.
I have the following two tables
LOAD ITEM_ID,
ITEM_DELI,
LARTAR,
CSECAR,
[SECTEUR DESCRIPTION],
CRAYAR,
[RAYON DESCRIPTION],
CFAMAR,
[DESCRIPTION FAMILY],
SUPPLIER_DELI,
RSOCFO,
BRAND,
BRAND_DESCR
FROM C:\DELIVERIES\QLIKVIEW\ITEMS_FINAL.xls (biff, embedded labels, table is [Sheet1$]);
LOAD [Brand Name],
[Supplier Code],
[Supplier Name],
Rayon,
[Rayon Descr],
Family,
[Family Descr],
ITEM_ID,
Amount
FROM C:\DELIVERIES\QLIKVIEW\DATA_FINAL.xls (biff, embedded labels, table is [Sheet1$]);
How can i have the common and uncommon items in a chart ?
For example if the ITEM_ID is equal with ITEM_DELI then give me the Amount else if the
ITEM_ID not equal with ITEM_DELI give me Amount 0 (Zero)
Thank you in advance.
