Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
yrstruly
Contributor

Basic Display Of Data in Qliksense

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 …

0 Replies