topic Re: Common and uncommon data in the same chart in QlikView

Common and uncommon data in the same chart

geogou1973 — Thu, 02 Jun 2016 09:25:39 GMT

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 — Thu, 02 Jun 2016 09:29:24 GMT

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

geogou1973 — Thu, 02 Jun 2016 10:12:24 GMT

Hi kushal

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

Kushal_Chawda — Thu, 02 Jun 2016 10:17:14 GMT

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