Common and uncommon data in the same chart

[geogou1973]

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.

[Kushal_Chawda]

=Sum({<ITEM_ID={"=ITEM_ID=ITEM_DELI "}>}Amount)

[geogou1973]

Hi kushal

This formula brings only the common data not the uncommon also.

[Kushal_Chawda]

Sum({<ITEM_ID={"=ITEM_ID=ITEM_DELI "}> + <ITEM_ID={"=ITEM_ID<>ITEM_DELI "}>}Amount)