topic Re: Carry Forward Issue ? in QlikView

Carry Forward Issue ?

Wed, 29 Oct 2014 14:40:31 GMT

HI All,

I am Having Customers with With Some Transactions...

Total Amount I am calculating on the Basis of Credit & Debit to Till the End of Each & Every Month...

Example:

Transactions are happened In then Total Amount is ---- Jan -200,

Feb--300,

June--600

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

Jan -200,

Feb--300,

Mar--300

Apr--300

May--300

June--600

Urgent...

Regards,

Helen

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

Re: Carry Forward Issue ?

morganaaron — Wed, 29 Oct 2014 15:04:36 GMT

Do you need this to be done in the script (i.e. where there is a null, look at the previous record) or in a table in the app?

A way to do it would be to create a chart-table with your month as the dimension, sum(amount) as the expression with full accumulation (so it accumulates as you go along) and then add an extra expression that just says 1 for example, hide this column in the presentation tab and ensure you sort by your Month field in load order if you've loaded in sequential order.

Not pretty (and I'm sure not the proper answer) but it would do what you want!

Re: Carry Forward Issue ?

Wed, 29 Oct 2014 18:40:00 GMT

HI All,

I am Having Customers with With Some Transactions...

Total Amount I am calculating on the Basis of Credit & Debit to Till the End of Each & Every Month...

Example:

Transactions are happened In then Total Amount is ---- Jan -200,

Feb--300,

June--600

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

Jan -200,

Feb--300,

Mar--300

Apr--300

May--300

June--600

Urgent...

Regards,

Helen

I need to get Mar,Apr, May also With the Feb Amount Should be Carry Forwarded

Re: Carry Forward Issue ?

maxgro — Wed, 29 Oct 2014 19:38:12 GMT

load rowno() as id, * inline [

month

Jan

Feb

Mar

Apr

May

June

];

left join (m)

load * inline [

month, tran

Jan,-200,

Feb,-300

June,-600

];

NoConcatenate

load

id,

month,

if(len(trim(tran))=0, peek(tran), tran) as tran

Resident m

order by id;

DROP Table m;

Re: Carry Forward Issue ?

Thu, 30 Oct 2014 07:47:54 GMT

HI Can you implement for this qvw...

cumulative issue?

Re: Carry Forward Issue ?

NavinReddy — Thu, 30 Oct 2014 18:35:28 GMT

plese check its helpful to you