After Applying Join not able to see data in UI design In charts

[sakshikaul]

Hi,

I have join the tables in qlikview but not able to see the data in charts.I have following tables 

1. buying master

2. style grading

3.Franchise grading  as shown below:-

 Following is the UI design in which I am not able to get buying master grade and style master grade. 

Why I am not able to get these grades ?

Please help 

[vitaliichupryna]

Hi Sakshikaul,

Looks like Item Number field in the Increment_Sales  table doesn't match with Item Number field In Buying_Master_Full and StyleGrading_Full table.

Thanks,

Vitalii

[sakshikaul]

Following are the tables (script)

Buying_Master_Full:

LOAD [Season Code] as Buying_Master_season ,
OSGENDER,
GENDER as Buying_Master_gender,
// MATERIAL,
// COLOR,
MATERIAL&COLOR as iitemNumber,

StyleGrading_Full:
//Concatenate(Increment_Sales)

LOAD GradeId,
ClusterGradeId,
StyleGrading_Partner_Code,
StyleGrading_Cluster,
Gender,
KGender,
[Season Code] as StyleGrading_Full_season,
Store,
Category,
SubCategory,
// MATERIAL,
// COLOR,
MATERIAL&COLOR as iitemNumber,

Increment_Sales:

LOAD SAPCode,

replace(ItemNumber,' ','') as ItemNumber, 

mid(ItemNumber,13,3) as COLOR,

mid(ItemNumber,13,3) & left(ItemNumber,13) as  iitemNumber,
left(ItemNumber,13) as Material,
[inv no],
Sold_Date,
lastDate,
CurrentDate,
Date(lastDate, 'YYYYMMDD') & Date(CurrentDate, 'YYYYMMDD') as EventKey,
Sold_Month,
Sold_Year,
ItemNumber,
[Season Code],
quantity_sold,
[tax amount]
FROM
[..\QVD\transform_qvd\IncrementSales_full.qvd]
(qvd);

I have joined following above tables . I have concatenated color and Material and renames as iitemnumber in each table still not getting the result .

[dplr-rn · Accepted solution]

itemnumbers in grade table should match with itemnumber on sales table.

to me the logic doesnt look right

MATERIAL&COLOR as iitemNumber,

[sakshikaul]

Hi,

iitemNumber In grade table is created by concatenating two fields ie MATERIAL&COLOR as iitemNumber,

similarly iitemnumber in sales table is created by concatenating two fields ie MATERIAL&COLOR as iitemNumber.

After executing the script I have now got the following result but now I am getting the same result for each grade so need help why this is happening ?

[dplr-rn]

Not sure what you mean.

If you share a sample app would be able to help

I would check the data consistency key fields between tables as a start

[sakshikaul]

Hi,

Please help ,e how to upload a document here?

[sakshikaul]

Hi 

I am not able to upload a sample application as size of application is too large.