Triangulations

sijojoseph22 — Fri, 18 Sep 2015 15:54:38 GMT

Hi All,

We are doing triangualations in our report. We are having below data (sample given). Please could you advise how to to the traingulations with this. Attached the qvw with the below data. Please let me know if any clarification is required.

Data

PolicyNumber	MonthClaim	Field	ReserveT
P1	1	UC1	50
P1	2	UC2	100
P1	3	UC2	200
P1	7	UC1	100
P1	7	UC2	150
P1	8	UC2	500
P1	12	UC2	250

Output we are looking in Triangulations

PolicyNumber	MonthClaim	ReserveT
P1	1	50	UC1=50
P1	2	150	UC2=100 + UC1=50
P1	3	250	UC2=200 + UC1=50
P1	4	250	UC2=200 + UC1=50
P1	5	250	UC2=200 + UC1=50
P1	6	250	UC2=200 + UC1=50
P1	7	250	UC2=150 + UC1=100
P1	8	600	UC2=500 + UC1=100
P1	9	600	UC2=500 + UC1=100
P1	10	600	UC2=500 + UC1=100
P1	11	600	UC2=500 + UC1=100
P1	12	350	UC2=250 + UC1=100

Thanks,
Sijo

Re: Triangulations

satishkurra — Fri, 18 Sep 2015 15:59:12 GMT

Use the expression

RangeSum(Above(Sum(ReverseT),0, RowNo()))

Re: Triangulations

sijojoseph22 — Fri, 18 Sep 2015 16:01:43 GMT

Thanks , But I need the sum based on the new value based on the field (UC1 or UC2). The above formula will not give that.

topic Re: Triangulations in QlikView

Triangulations

Re: Triangulations

Re: Triangulations