Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min and Max Date Dimensionality?

First time poster so forgive my explanation.

Background:

I work at an insurance company and I would like to build a viz (QlikView) on claims loss amounts growth/decay.  My idea is to have a scatter chart that plots a claim by loss amount (Y) and transaction date (X) twice.  One dot be the first transaction connected to the second dot to be the last transaction on the claim.  I'm having trouble building out the logic to plot the two points.

Question:

How can I plot a claim on its initial loss amount on its first transaction date as well as plot its total loss amount on its final transaction date?  Adding the connecting line should be simple enough by adding Claim Number as the second dimension on the scatter (correct me if I'm under-thinking it).

Bonus question:

Can I conditionally format the color of the connecting line based on the slope of the line (red for sizable positive slope, green for a sizable negative slope and yellow for a flat-ish slope)?

Thank you in advance for any consideration.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That's a pretty interesting idea. Attached is a rough cut, see what you can make of it.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

6 Replies
vishsaggi
Champion III
Champion III

Can you share some sample data would be easy to look into and try?

Not applicable
Author

Sample data, applying the same concept to CustomerID and Sales over YYYYMM.

Not applicable
Author

Not sure if you get notified when I reply to myself.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

That's a pretty interesting idea. Attached is a rough cut, see what you can make of it.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable
Author

This looks awesome! Thanks Rob.

I don't think the max trandate is calculating sales cumulatively though.  It is only providing the sale amount for the latest transaction.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I just guessed at what you wanted. You can modify the script to sum the Sales like in the attached.

-Rob