topic Re: Help needed with chart in QlikView

Help needed with chart

Tue, 31 Mar 2015 14:00:34 GMT

Hi I need some help if anyone can help please. I am looking to chart sales on Policy 2012 highlighting policy renewal, created and premium with trend line.

Kind Regards

Re: Help needed with chart

morganaaron — Tue, 31 Mar 2015 14:46:06 GMT

Hi Jack,

Is this one of the charts within your .qvw, or a new chart entirely? Have you attempted to chart the data yourself and failed, or are you asking where to start in terms of creating this type of chart?

Re: Help needed with chart

Tue, 31 Mar 2015 14:51:01 GMT

Hi Aaron

I have attempted and failed, I attempted with Policy Month Created as my dimension, and expressions, sum of policy counter, sum of policy renewed, sum of premium.

Regards

Jack

Re: Help needed with chart

avinashelite — Tue, 31 Mar 2015 14:52:29 GMT

Hi jack,

Can you elaborate a bit about your requirement ?? On what basis you need the trend line i,e dimension for that

Re: Help needed with chart

Tue, 31 Mar 2015 15:07:59 GMT

Hi Avinash

I am trying to chart the the policy renewal and cancellations in a bar chart yous the policy counter as the number of items. I want to use a trend line to highlight the premium £

Regards

Re: Help needed with chart

avinashelite — Tue, 31 Mar 2015 15:09:39 GMT

How do you identify its renewal or cancellation policy ??

Re: Help needed with chart

morganaaron — Tue, 31 Mar 2015 15:10:56 GMT

What was the issue in terms of it not showing what you wanted? I created a simple chart using the Policy Created Month Year and was able to get sensible results for each of those, all be it there seems to have been a batch load of policies to begin with at the minimum date available. Beware that with Policy Month Created you'd be adding all the years data together grouped by month.

Also, beware that your policy renewed? field is a yes/no text field, so you can't sum this data - you'd need to count where it equals to yes I assume, there are a few ways to do that, Count({<[PolicyRenewed?]={'Yes'}>}PolicyCounter) would give you a valid expression.

The likelihood may simply be your initial batch load is skewing the data so you can't see any of the other values?

Re: Help needed with chart

morganaaron — Tue, 31 Mar 2015 15:20:19 GMT

See attached as an example to what I'm saying above. I've selected two years that ignore the 2001 and 2007 spikes to highlight the functionality without those extreme values.

Re: Help needed with chart

Tue, 31 Mar 2015 15:28:33 GMT

Thank Aaron

That is more or less the information I was looking to display.

Regards

Jack

Re: Help needed with chart

Tue, 31 Mar 2015 15:29:25 GMT

Thanks Avinash

I have now found a solution, thank you

Regards

Jack

Re: Help needed with chart

avinashelite — Tue, 31 Mar 2015 15:39:49 GMT

Thanks ...feel free to post questions