topic Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data in QlikView

Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

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

Would Somebody Please Assist?

Here follows Instructions:

Import tables: ClaimsListing, ClaimsMaster, RegionDescription.
PS - Note that the delimiter is ','

(i)The description for "CLAIM TYPE CODE" is in the table GetClaimType

(ii) Display the Excesss Total Value per Unique Claim entry on the ClaimsListing table by adding the different type of Excesses together.

(iii) Ensure your date selection has an option to view data by Incident Period (MM/YYYY).

See Data Model Attached:

Please Note that there is two non related tables. According to the assignment. I must display Incident Period (MM/YYYY). I

can only do that when i i bring in my non related tables or am i wrong please correct me?

Also is my Straight Table Display Correct? Please find data here(without bugs): https://drive.google.com/open?id=1NzkGzOr4-b9gqQiRkVR_khqQYtD_pQVz

Thank You In Advance.

Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

adityaakshaya — Thu, 06 Dec 2018 05:49:05 GMT

Hi,
While going through the data model, I can see synthetic keys are there. Please remove those and also, can you let me know the application name on the drive you shared so that I can give a try on this.

Regards,
Akshaya

Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

yrstruly — Thu, 06 Dec 2018 09:15:41 GMT

https://drive.google.com/file/d/1_hOz1P2YY_IAvQeHkXc64JBRZE-VfhVS/view?usp=drivesdk

Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

yrstruly — Tue, 11 Dec 2018 07:48:48 GMT

whats the verdict?

Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

adityaakshaya — Wed, 12 Dec 2018 21:20:50 GMT

Hi ,

Sorry for replying late.

I went through your data model. There are few question where I need some clarification.

1. Is Policy Number a unique row identifier?

2. Do you want to add catastrophe with incident date in claim master

3. I could see Claim status table contains claim type code details. am I correct?

Regards,

Akshaya

Re: Straight Table & Incorporating Non Relational Data Into Model To Display Required Data

yrstruly — Wed, 12 Dec 2018 21:39:04 GMT

Hello Thank You For The Reply.

1. Is Policy Number a unique row identifier?

I Believe it's suppose to be, i seem to have found duplicates have you?

2. Do you want to add catastrophe with incident date in claim master?

I think that's the way to bring in the desired visualization as instructed?

3. I could see Claim status table contains claim type code details. am I correct?

Yes. If you look at the requirements from step 1 you will see that there are two tables not part of the Snowflake Data Model. I am available via Team viewer, are you?