topic Re: Re: Carrying Data from Previous to Current YearProblem in QlikView

Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 07:40:42 GMT

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

Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Tue, 23 Sep 2014 07:48:25 GMT

Like this

regards

ASHFAQ

Re: Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 07:55:28 GMT

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

Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Tue, 23 Sep 2014 07:59:26 GMT

Hi,

Its working with year selections too isn't it?

Can you post you expected output?

Regards

ASHFAQ

Re: Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 08:08:44 GMT

hi,

It is not working with Year selection.

PFA

Re: Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 08:26:28 GMT

hi,

I have taken a straight table to represent the amount

can you let us know what to do

Re: Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Tue, 23 Sep 2014 08:35:24 GMT

Hi,

Check this

Regards

ASHFAQ

Re: Re: Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 08:54:52 GMT

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

Re: Re: Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Tue, 23 Sep 2014 09:03:08 GMT

Hi,

isn't it too much

any ways have a look at attached document

Regards

ASHFA

Re: Re: Carrying Data from Previous to Current YearProblem

Tue, 23 Sep 2014 09:11:50 GMT

hi ,

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

PFA,

Regards,

Divya

Re: Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Tue, 23 Sep 2014 09:18:53 GMT

It will not work like that.

regards

ASHFAQ

Re: Re: Carrying Data from Previous to Current YearProblem

Wed, 24 Sep 2014 05:51:24 GMT

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

Re: Re: Re: Carrying Data from Previous to Current YearProblem

ashfaq_haseeb — Wed, 24 Sep 2014 05:59:04 GMT

Have a look at attached image.

and application too I applied your formula.

As per your requirement it should

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

Which is not the case its still showing 200.

My solution even worked till here.

anyhow if its fixed your issue. I'm happy for you

Regards

ASHFAQ

Re: Re: Carrying Data from Previous to Current YearProblem

Wed, 24 Sep 2014 06:07:46 GMT

Hi Ashaf,

Thank you.

In that graph .We have to enable No Accumulation.

PFA.

thanks for your Suggestions

Regards,

Divya