Scenario Logic Help

abhaysingh — Sat, 20 Feb 2016 16:33:37 GMT

Hi Every One,

Pls find the attached QVW and Sample Data with it,

In this u will see the DataModel Having Synthetic keys, and expected output in Table at GUI,

In table Holidays calendar, there are Holidays w.r.t Plant code , profit centre and material group, in second excel there is data w.r.t.

Plant code , profit centre ,material group,division,and itemcode

if i join these table to get the data w.r.t division,and itemcode in Holidays calendar my data is getting multiplying and getting wrong output,

so what is the other way to get the data for working calendar for dimension Division and itemcode as well, Count of Holidays available in excel should not increase, the same value shud repeat to Division and relevant itemcode. as showed in output expected table.

Hope m clear with what i want.

in short i want to remove that sync key and want

division,and itemcode dimension in working calendar table with expected output

pls suggest

thanks

Re: Scenario Logic Help

Gysbert_Wassenaar — Sat, 20 Feb 2016 16:55:43 GMT

Simply join the two tables together into one table.

Tab1:

LOAD trim(Plant) as PlantCode,

trim([Profit Centre]) as Profit_Centre,

trim([Material Group]) as Material_Grp,

Date(Date#(Holidays,'DD.MM.YYYY'),'DD-MM-YYYY') as Holidays,

month( Date(Date#(Holidays,'DD.MM.YYYY'),'DD-MM-YYYY') ) as month

FROM

(biff, embedded labels, table is Sheet1$);

JOIN (Tab1)

LOAD PlantCode,

Profit_Centre,

Material_Grp,

Itemcode,

Division

FROM

C:\Users\admin\Desktop\MasterDataCommunity.xls

(biff, embedded labels, table is Sheet1$);

topic Re: Scenario Logic Help in QlikView

Scenario Logic Help

Re: Scenario Logic Help