Solved: Carrying Data from Previous to Current YearProblem - Qlik Community

Report Inappropriate Content · ‎2014-09-23

Hi Everyone,

I am using Below Expression.In order to get data

Sum(Amount)

It is Working fine in Text object.but in graph if i select it is giving data till 2013 Jan to 2013 Dec.

I need that data should carry forward to next Year

Pls suggest me.

PFA,

Regards,

Divya

Report Inappropriate Content · ‎2014-09-24

Hi Ashaf,

The below expression solves it.

RangeSum(Above(Sum (Amount), 0,RowNo()))+Sum(TOTAL{$<M=,Y={$(varMaxPrevYear)}>}Amount)

It is working fine.

Regards,

Divya

View solution in original post

ashfaq_haseeb · ‎2014-09-23

Like this

regards

ASHFAQ

Report Inappropriate Content · ‎2014-09-23

Hi ,

Thanks for the reply it is like that only .When i select 2013 or 2014 based on Year selection it should give values.

Suggest me

Regards,

Divya

ashfaq_haseeb · ‎2014-09-23

Hi,

Its working with year selections too isn't it?

Can you post you expected output?

Regards

ASHFAQ

Report Inappropriate Content · ‎2014-09-23

hi,

It is not working with Year selection.

PFA

Report Inappropriate Content · ‎2014-09-23

hi,

I have taken a straight table to represent the amount

can you let us know what to do

ashfaq_haseeb · ‎2014-09-23

Hi,

Check this

Regards

ASHFAQ

Report Inappropriate Content · ‎2014-09-23

hi Ashaf,

Now the values are correct .Thanks a lot

But i need it for till current month not till previous month end .

one more thing is when i select 2013.it should show jan2013 to Dec2013 and if i select 2014 ,it should show 2014Jan to Dec2014.

Regards,

Divya

ashfaq_haseeb · ‎2014-09-23

Hi,

isn't it too much

any ways have a look at attached document

Regards

ASHFA

Report Inappropriate Content · ‎2014-09-23

hi ,

When i select 2014,the value for jan2014should be 2600 but it showing only 200.

PFA,

Regards,

Divya