Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

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

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:-

Untitled.png 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 ?

Untitled.png

Please help 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

to me the logic doesnt look right

MATERIAL&COLOR as iitemNumber,

View solution in original post

7 Replies
vitaliichupryna
Creator III
Creator III

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
Creator II
Creator II
Author

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
Partner - Master III
Partner - Master III

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

to me the logic doesnt look right

MATERIAL&COLOR as iitemNumber,

sakshikaul
Creator II
Creator II
Author

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 ?Untitled.png

 

dplr-rn
Partner - Master III
Partner - Master III

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
Creator II
Creator II
Author

Hi,

Please help ,e how to upload a document here?

sakshikaul
Creator II
Creator II
Author

Hi 

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