Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Data model Image please?
Cant provide image due to security in Laptop
Fine, Do you have common data with that? At least provide Table box after selecting the data using [Year Week] and Data ??
Region | Branch | P2 | Tech | DistyCode | BuyerCode | Sell Thru Band | MSN | SCR | Optimum Stock Norm | ClosingStk | Suggested Order |
SOUTH 1 | CHENNAI | MWO | CONV | 1389255 | TAMD6003803 | 20 Lac+ | 4 | 2 | 4 | 0 | 4 |
SOUTH 1 | CHENNAI | MWO | GRILL | 1389255 | TAMD6003803 | 20 Lac+ | 0 | 1 | 1 | 0 | 1 |
SOUTH 1 | CHENNAI | MWO | SOLO | 1389255 | TAMD6003803 | 20 Lac+ | 3 | 0 | 3 | 0 | 3 |
SOUTH 1 | CHENNAI | PANEL | 32 | 1389255 | TAMD6003803 | 20 Lac+ | 105 | 60 | 105 | 0 | 105 |
SOUTH 1 | CHENNAI | PANEL | <32 | 1389255 | TAMD6003803 | 20 Lac+ | 47 | 25 | 47 | 0 | 47 |
SOUTH 1 | CHENNAI | PANEL | 40-43 | 1389255 | TAMD6003803 | 20 Lac+ | 24 | 7 | 24 | 0 | 24 |
SOUTH 1 | CHENNAI | REF | DC | 1389255 | TAMD6003803 | 20 Lac+ | 105 | 61 | 105 | 0 | 105 |
SOUTH 1 | CHENNAI | REF | FF-HOME | 1389255 | TAMD6003803 | 20 Lac+ | 16 | 0 | 16 | 0 | 16 |
SOUTH 1 | CHENNAI | REF | FF-SBS | 1389255 | TAMD6003803 | 20 Lac+ | 2 | 0 | 2 | 0 | 2 |
SOUTH 1 | CHENNAI | SAC | SPLIT | 1389255 | TAMD6003803 | 20 Lac+ | 57 | 2 | 57 | 0 | 57 |
SOUTH 1 | CHENNAI | WM | FAFL | 1389255 | TAMD6003803 | 20 Lac+ | 7 | 5 | 7 | 0 | 7 |
SOUTH 1 | CHENNAI | WM | FATL | 1389255 | TAMD6003803 | 20 Lac+ | 36 | 32 | 36 | 0 | 36 |
SOUTH 1 | CHENNAI | WM | SAWM | 1389255 | TAMD6003803 | 20 Lac+ | 10 | 3 | 10 | 0 | 10 |
My Data Model linking is not correct
Then Practice start from Data model in your application https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/
Hi
You are not having YearWeek field in MSN Table, how come you are linking that table?
Have you made any composite key?
Why are concatenating everything when the structure is not same ? Are you trying to create a link table using this forced concatenate ?
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.