topic Re: Creating Data Model for Different KPI's in QlikView

Creating Data Model for Different KPI's

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Table 1) Stock :

Stock Table:

Tech

SoldToCode

BuyerCode

Region

Branch

AI Sell Thru Band

YearMonth

YearWeek

Date

Opening Qty

Closing Qty

Sellthru Qty

Pending Order

MSNTable:

Tech

SoldToCode

BuyerCode

Region

Branch

AI Sell Thru Band

YearMonth

MSN

SCR Table:

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.

Re: Creating Data Model for Different KPI's

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:07:54 GMT

Data model Image please?

Re: Creating Data Model for Different KPI's

Anonymous — Sun, 04 Feb 2018 12:09:19 GMT

Cant provide image due to security in Laptop

Re: Creating Data Model for Different KPI's

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:11:59 GMT

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

Re: Creating Data Model for Different KPI's

Anonymous — Sun, 04 Feb 2018 12:14:08 GMT

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

Re: Creating Data Model for Different KPI's

Anonymous — Sun, 04 Feb 2018 12:14:38 GMT

My Data Model linking is not correct

Re: Creating Data Model for Different KPI's

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:17:44 GMT

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

Re: Creating Data Model for Different KPI's

shiveshsingh — Mon, 05 Feb 2018 06:10:23 GMT

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

Have you made any composite key?

Re: Creating Data Model for Different KPI's

qliksus — Tue, 06 Feb 2018 03:22:16 GMT

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

Re: Creating Data Model for Different KPI's

jonathandienst — Tue, 06 Feb 2018 04:54:16 GMT

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.