topic Re: Data Model help in QlikView

Data Model help

Thu, 11 Feb 2016 22:14:21 GMT

Hi,

I am hoping I can get some feedback. Attached is the data model of my app.

I am trying to Separate the complaints / Item master from the ship data but both of them are connected by the calendar.

My Complaint data is spot on with the calculations, but the ship data sum is way off.

Any suggestions?

Re: Data Model help

sfatoux72 — Thu, 11 Feb 2016 22:48:15 GMT

I'm not sure to understand your problem.

But what if you create one calendar for Complaint and another one for Ship Data.

Re: Data Model help

Fri, 12 Feb 2016 00:49:56 GMT

That Did it - I will probably have to relate the 2 datasets eventually, but at least my numbers are making sense

thank you

Re: Data Model help

ramasaisaksoft — Fri, 12 Feb 2016 07:02:15 GMT

Hi Leo,

I am not understand your problem properly.

As per my understanding just you want to separate data model into 2 parts

1st part:-Ship Data ,Master Calendar

2nd part:-Complaints,Item Master

so just you can rename "ComplaintCreationDate" as "complaintcreationdat" in any one of the table so that the key in between Master calendar & Complaint will remove.

so that u can see 4 tables with 2 keys only

Re: Data Model help

Fri, 12 Feb 2016 07:24:38 GMT

Hi Leo,

Both the Ship data and complaints are to be separated? Wouldn't you want to report on the complaints per shipment? Your current model above allows this at least by the aggregated date level, so the dates are the key to linking these 2 data-sets. If we split, this will create 2 separate data islands unless you have some other key field to link Shipment to their complaints.

As for the calculations, it depends on what date you are looking at when you are reconciliating and what is bounded by your set analysis and date selection.

Hope I make sense.

Thanks

Ram