6 Replies Latest reply: Sep 28, 2017 12:18 PM by Rob Wunderlich

# 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.

• ###### Re: Min and Max Date Dimensionality?

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

• ###### Re: Min and Max Date Dimensionality?

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

• ###### Re: Min and Max Date Dimensionality?

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

• ###### Re: Min and Max Date Dimensionality?

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

-Rob

http://qlikviewcookbook.com

• ###### Re: Min and Max Date Dimensionality?

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.

• ###### Re: Min and Max Date Dimensionality?

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

-Rob