Hello I need help for this toughy problem.
I receive file with this data : client id, start date, end date, premium amount. I want to split this line into months to calculate exposure : example :
input file :
a0001 15/01/2014 10/03/2014 55
output file :
a0001 15/01/2014 31/01/2014 17
a0001 01/02/2014 28/02/2014 28
a0001 01/03/2014 10/03/2014 10
This can be managed via a qvd file if necessary.
I know this can be easily fixed with SAS but I really need to do it with Qlikview.
thanks for you help.
