topic Re: Spread Income in QlikView

Spread Income

gidon500 — Wed, 12 Nov 2014 05:51:40 GMT

Hi guys

i have a request from a customers who whats to spead income according to fixed rules

for each customer i get invoice number , date , sales amount and numbers of months to speard

each invoice can get different no of months .

those sales as service contracts , so in finance report , the CFO need to spread the income

for the life of the contracts .

enclosed is a file where the yellow colour is the data i get

and green is the data i need to create

the file is a sample , the real file is very big

thanks

gidon

MK_QSL — Wed, 12 Nov 2014 08:02:16 GMT

Use below script

================================

Temp:

Load *, Months as TotalMonths Inline

[

Customer, Date, Invoice, Sales, Months

200, 01/02/2014, I100, 5000, 5

210, 01/04/2014, I150, 7200, 6

];

NoConcatenate

Data:

Load

Customer,

Date(AddMonths(Date,(IterNo()-1))) as Date,

Invoice & '-' & (IterNo()) as Invoice,

Sales/TotalMonths as Sales,

Months

Resident Temp

While IterNo() <= Months;

Drop Table Temp;

gidon500 — Wed, 12 Nov 2014 08:42:55 GMT

hello

thanks for your help

gidon