topic Re: Basic Display Of Data in Qlikview in QlikView

Basic Display Of Data in Qlikview

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

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 …

Re: Basic Display Of Data in Qlikview

marcus_malinow — Mon, 19 Nov 2018 13:49:06 GMT

What specific questions do you have?

This looks like a test, which really you should attempt yourself.

Re: Basic Display Of Data in Qlikview

jobsonkjoseph — Mon, 19 Nov 2018 14:16:52 GMT

Hi Buddy, Looks like a test has been assigned to you. OK, here's some tips for you to build this application; 1. Use 3 tier Architecture here. 2. Open QV, load each excel and create separate QVD's. There are 5 excel documents, so create 5 QVD's. 3. Open another qvw(new), load all 5 QVD's and check for any modification, transformations etc., 4. finally open another qvw, Do a binary load of previous qvw. 5. Start your visualizations on the 3rd qvw.

Re: Basic Display Of Data in Qlikview

yrstruly — Mon, 19 Nov 2018 14:22:45 GMT

Hi Thank you for the feedback. Yes, it was meant for me but i am seeking assistance that's why i reached out to this forum. Can you break it down for me? Your explanation is not helpful or suited for a beginner please?

Re: Basic Display Of Data in Qlikview

jobsonkjoseph — Mon, 19 Nov 2018 14:28:35 GMT

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.

Re: Basic Display Of Data in Qlikview

yrstruly — Mon, 19 Nov 2018 14:37:32 GMT

I'm a beginner. I am working through"QlikView 11 for Developers". I'm at Ch.4

Re: Basic Display Of Data in Qlikview

jobsonkjoseph — Mon, 19 Nov 2018 16:24:31 GMT

This will require me to author a HOW TO on developing an application. it'll take sometime to write the steps and make you understand. easy way is pls get in touch with me @ jobsonkjoseph@gmail.com , if possible i'll take remote of your computer and guide you the entire process.

Re: Basic Display Of Data in Qlikview

yrstruly — Tue, 20 Nov 2018 06:13:23 GMT

Thank You! I'm Grateful.

Re: Basic Display Of Data in Qlikview

yrstruly — Tue, 20 Nov 2018 06:54:04 GMT

I sent you an email?