Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can somebody assist me these Questions please? Data is attached.
1) Import tables: ClaimsListing, ClaimsMaster, RegionDescription.
PS - Note that the delimiter is ','
2) The description for "CLAIM TYPE CODE" is in the table GetClaimType
3) Display the Excesss Total Value per Unique Claim entry on the ClaimsListing table by adding the different type of Excesses together.
4) Ensure your date selection has an option to view data by Incident Period (MM/YYYY).
5) Display the total of "AUTHORISED AMOUNT" for all claims of which the "INCIDENT DATE" fell within the date range of each
Catastrophy start and end date (Excel Document 'Catastrophy Incidents'). If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value.
For this view, you should only include claims where the CLAIM STATUS is not equal to 'R' or 'Z'.
6) Use the Claims data to provide useful views.
-----------------------------
Please see: https://drive.google.com/open?id=1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3 … AND https://drive.google.com/open?id=1Bdq0jxJ0g5cXg2jK_1YjUlr-josKXnkD …
What specific questions do you have?
This looks like a test, which really you should attempt yourself.
ok.
So you want to develop an application from scratch. great. glad you chose QV as a career path.
Now moving onto your requirement.
You are asked to create an application with specific requirements. An application needs a data model for visualizations/reporting to be done.
For creating a data model, you need data. As your data is in excel, its easy to load them in QV.
Before continuing, what is your experience into QV, I mean what are you well versed with.
I'm a beginner. I am working through"QlikView 11 for Developers". I'm at Ch.4
Thank You! I'm Grateful.
I sent you an email?