Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=Sum({<ITEM_ID={"=ITEM_ID=ITEM_DELI "}>}Amount)
Hi kushal
This formula brings only the common data not the uncommon also.
Sum({<ITEM_ID={"=ITEM_ID=ITEM_DELI "}> + <ITEM_ID={"=ITEM_ID<>ITEM_DELI "}>}Amount)