Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creating Data Model for Different KPI's

I have 5 tables with different Date type fields, I want to concatenate and link them all.

Table 1) Stock  :

Stock Table:
P2
Tech
SoldToCode
BuyerCode
Region
Branch
AI Sell Thru Band
YearMonth
YearWeek
Date
Opening Qty
Closing Qty
Sellthru Qty
Pending Order

MSNTable:
P2
Tech
SoldToCode
BuyerCode
Region
Branch
AI Sell Thru Band
YearMonth
MSN

SCR Table:
P2
Tech
SoldToCode
BuyerCode
Region
Branch
AI Sell Thru Band
YearWeek
SCR

Last4Week SelloutTable:
P2
Tech
SoldToCode
BuyerCode
Region
Branch
YearWeek
sellout

Last4Week Sellthru Table:
P2
Tech
SoldToCode
BuyerCode
Region
Branch
YearWeek
sellout

I have concatenatd tables but with Year Week Selection My Data is getting 0. 

9 Replies
Anil_Babu_Samineni

Data model Image please?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Cant provide image due to security in Laptop

Anil_Babu_Samineni

Fine, Do you have common data with that? At least provide Table box after selecting the data using [Year Week] and Data ??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

RegionBranchP2TechDistyCodeBuyerCodeSell Thru BandMSNSCROptimum Stock NormClosingStkSuggested Order
SOUTH 1CHENNAIMWOCONV1389255TAMD600380320 Lac+42404
SOUTH 1CHENNAIMWOGRILL1389255TAMD600380320 Lac+01101
SOUTH 1CHENNAIMWOSOLO1389255TAMD600380320 Lac+30303
SOUTH 1CHENNAIPANEL321389255TAMD600380320 Lac+105601050105
SOUTH 1CHENNAIPANEL<321389255TAMD600380320 Lac+472547047
SOUTH 1CHENNAIPANEL40-431389255TAMD600380320 Lac+24724024
SOUTH 1CHENNAIREFDC1389255TAMD600380320 Lac+105611050105
SOUTH 1CHENNAIREFFF-HOME1389255TAMD600380320 Lac+16016016
SOUTH 1CHENNAIREFFF-SBS1389255TAMD600380320 Lac+20202
SOUTH 1CHENNAISACSPLIT1389255TAMD600380320 Lac+57257057
SOUTH 1CHENNAIWMFAFL1389255TAMD600380320 Lac+75707
SOUTH 1CHENNAIWMFATL1389255TAMD600380320 Lac+363236036
SOUTH 1CHENNAIWMSAWM1389255TAMD600380320 Lac+10310010
Anonymous
Not applicable
Author

My Data Model linking is not correct

Anil_Babu_Samineni

Then Practice start from Data model in your application https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
shiveshsingh
Master
Master

Hi

You are not having YearWeek field in MSN Table, how come you are linking that table?

Have you made any composite key?

qliksus
Specialist II
Specialist II

Why are concatenating  everything when the structure is not same ? Are you trying to create a link table using this forced concatenate ?

jonathandienst
Partner - Champion III
Partner - Champion III

You might want to Join rather than concatenate. That will help with handling the different granularity. The common fields for the join would be P2, Tech, SoldToCode, BuyerCode, Region and Branch.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein