Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data Model help

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?

1 Solution

Accepted Solutions
sfatoux72
Valued Contributor

Re: Data Model help

I'm not sure to understand your problem.

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

4 Replies
sfatoux72
Valued Contributor

Re: Data Model help

I'm not sure to understand your problem.

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

Not applicable

Re: Data Model help

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

thank you

ramasaisaksoft
Valued Contributor III

Re: Data Model help

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

Not applicable

Re: Data Model help

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

Community Browser