Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

arjanijlenhave
New Contributor

End of year totals

Hi all,

I have the following source data and i want to create end of year totals. Can you help?

BOOKING DATA:   

Name insuresLoss numberDate of lossBooking nr.BookdateIncurredPaid
A13-4-201513-4-2015625000500000
A13-4-2015212-7-2016-1000000
A13-4-201533-5-2017500000
B27-7-201549-7-201511000060000
B27-7-201558-8-2017-500000
C312-12-2016612-12-20162500025000

An object that i want to create:

     

Name insuredLoss
number
Date of loss 31-12-201531-12-201631-12-2017
A13-apr-15Incurred625.000525.000575.000
Paid500.000500.000500.000
Outstanding125.00025.00075.000
B27-jul-15Incurred110.000110.00060.000
Paid60.00060.00060.000
Outstanding50.00050.0000
C312-dec-16Incurred025.00025.000
Paid025.00025.000
Outstanding000

In this example you see 3 years of data, but i want to show varaible 3, 4, 5, 6, .. years of booking data.

Regards,

Arjan

2 Replies
YoussefBelloum
Esteemed Contributor

Re: End of year totals

Hi,

so here you transformed Bookdate = 3-4-2015 to 31-12-2015 ??

arjanijlenhave
New Contributor

Re: End of year totals

Hi,

I haven't transformed bookdate. I want in the colums the end of year standings. For example: 31-12-2015 gives a total of all bookdates <= 31-12-2015.

Community Browser