topic Re: Chart Sum Values Help in QlikView

Chart Sum Values Help

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

Hello All,

I hope this is an easy question, I will try to explain as best as possible.I have a chart, sample attached, which has two policy ID's within the same date period. What I want is for all the Claim ID's to show the same value, which is the sum of the two premium values.Policy 1 has Premium = 100000 and Policy 2 has Premium = 200000. I want to do this in the chart expression.

Basically I have this:

What I want is this:

Any help is appreciated.

Re: Chart Sum Values Help

vishsaggi — Wed, 28 Jun 2017 19:08:40 GMT

May be this:

= Sum(TOTAL [Premium])

Re: Chart Sum Values Help

sterno14 — Wed, 28 Jun 2017 19:23:58 GMT

Thanks for the quick reply. I probably should have included a larger sampling. The issue I have with Total is that if there are additional policy ID's for other dates then using Sum(TOTAL [Premium]) will show that value on all rows (Policy 3, Period 2017, Valuation Date 5/31/2017, premium 150000)?. I need to limit to the particular Period & Valuation Date

Re: Chart Sum Values Help

vishsaggi — Wed, 28 Jun 2017 20:12:18 GMT

Can you add some sample or update your qvw and give me your expected output?

Re: Chart Sum Values Help

sterno14 — Wed, 28 Jun 2017 20:52:44 GMT

I updated the qvw. Here is what I want:

Re: Chart Sum Values Help

vishsaggi — Wed, 28 Jun 2017 21:12:23 GMT

use this:

= Sum(Total <[Valuation Date] > [Premium])

Re: Chart Sum Values Help

sterno14 — Wed, 28 Jun 2017 21:38:07 GMT

Thanks. That works. So that acts as group by essentially. Thanks for the help.

Re: Chart Sum Values Help

vishsaggi — Thu, 29 Jun 2017 12:14:13 GMT

Yes.