topic Re: Expression in QlikView

Expression

upaliwije — Thu, 11 Jul 2019 08:47:24 GMT

Hi Friends,

In my qlikview Doc. relating to insurance policy data I have the following Pivot Table and the expected Pivot table. In this case when a policy is Renewed after paying a claim I want to show it under Claims Paid & Renewed but here it is shown under Claims not Paid & Renewed Pls help me to get it corrected. I have attached my sample QV doc as well.

Re: Expression

jwaligora — Thu, 11 Jul 2019 18:34:16 GMT

Can you clarify your acronyms?

I can see Net Renewed and Not Renewed columns, but which columns report whether the policy has been paid?

Also, is it OK that Not Renewed for the period 2016-2017 is a negative value?

Re: Expression

upaliwije — Fri, 12 Jul 2019 03:21:43 GMT

If Sum(CNOS) column shows a positive value then the Policy is paid. There can not be negative value in not renewed column

Re: Expression

jwaligora — Fri, 12 Jul 2019 15:05:37 GMT

In this case, perhaps you should validate your pre-calculations.

When the policy data is expanded,

the 2015-2016 period is paid and not renewed,
the 2016-2017 period is not paid, 2 policies are renewed. The NOT renewed holds an illegal (-ve) value.

Either way, to achieve the targeted end, you could try something like the last 2 columns here: