topic Re: Set Analysis Problem in QlikView

Set Analysis Problem

Mon, 22 Sep 2014 14:04:54 GMT

Hi everyone,

I am using the below Expression in order to get data from database start date to till Previous Month end .

=Sum({$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

It is Working fine with Text box Object,but when i use the same expression in Chart object.It is just giving Current month sum.

Dimension is M.

PFA,

please suggest me .Little urgent.

Mon, 22 Sep 2014 14:37:25 GMT

Hi!

I guess you want to show something like this:

You can make it with the "Full accumulation" option in the properties (this image is from google, ignore the red circle):

I hope it helped!

Mon, 22 Sep 2014 15:04:10 GMT

Not sure how your app looks, but you need probably to use an ALL or a TOTAL.

All calculations is done in a chart in regards to the dimension unless you specify it should go outside of that limitation

=Sum(ALL {$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

Cheers,

Martin