How to manage total outlets vs ordered outlets in ... - Qlik Community

Anonymous · ‎2016-05-16

@I am trying to manage tables for total outlets vs ordered outlets in QVW but getting LOOPs.

Is anyone have solution for this issue. Please help to sort out it.

Table: Schedule_Outlets
Outlet_Code	Sales_Man_Code	CategoryID
T00019003004005	1003	A001
T00019003004003	1003	A001
T00019003004006	1003	A001
T00019003004009	1003	A001
Table: Product
CategoryID	ProductCode	ProductName
A001	30008	Chocolate 200g
A001	30009	Chocolate 300g
A001	30010	Milk Chocolate 200g
Table: Order
OrderID	Order_Date	ProductCode	Outlet_Code
AZ1610045769	05/01/2016	30009	T00019003004003
AZ1610045769	05/01/2016	300010	T00019003004003
AZ1610045770	06/01/2016	30008	T00019003004006
AZ1610045770	06/01/2016	30009	T00019003004006
AZ1610045770	06/01/2016	30010	T00019003004006
How to join these tables because I am getting "LOOP" when I join then in QVW
I need following results.
ProductCode	From_Date	To_Date	Total_Schedule_Outlets	Total_Productive_Outlets	%age
30009	05/01/2016	06/01/2016	4	2	50%

Anonymous · ‎2016-05-23

Does anyone have solution for this issue, please help

sunny_talwar · ‎2016-05-23

If this isn't resolved why have you masked it as assumed answer? Remove that so that people can consider helping you

Anonymous · ‎2016-05-23

Now there is no option to remove assumed answer

Please help if you have solution.

Anonymous · ‎2016-05-28

Please help if you have its solution

sunny_talwar · ‎2016-05-28

Is this what you are trying to get?

Script:

Schedule_Outlets:

LOAD Outlet_Code,

Sales_Man_Code,

CategoryID as CatID

FROM

[Total Outlets Vs Ordered Outlets by Product.xlsx]

(ooxml, embedded labels, table is Schedule_Outlets);

Product:

LOAD CategoryID,

ProductCode,

ProductName

FROM

[Total Outlets Vs Ordered Outlets by Product.xlsx]

(ooxml, embedded labels, table is Product);

Order:

LOAD OrderID,

Order_Date,

ProductCode,

Outlet_Code

FROM

[Total Outlets Vs Ordered Outlets by Product.xlsx]

(ooxml, embedded labels, table is Order);

Data Model:

Anonymous · ‎2016-05-29

Thanks for sparing your time, I appreciate.

Yes I need similar results but 'Total_Schedule_Outlets' should be count of all outlets those belong to relevant Product CategoryID.

By given solution QlikView shows Schedule Outlets with EQUAL join to Productive Outlets at my end. i.e. Schedule 2 & Productive 2.

How did you calculate 4 in Schedule Outlets ?

sunny_talwar · ‎2016-05-30

I am not sure I follow you Imran. Would you be able to elaborate?

How to manage total outlets vs ordered outlets in data model