Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Problem

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.

1 Solution

Accepted Solutions
Not applicable
Author

Hi!

I guess you want to show something like this:

HELP.png

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

Chart+accumulation+(2).jpg

I hope it helped!

View solution in original post

2 Replies
Not applicable
Author

Hi!

I guess you want to show something like this:

HELP.png

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

Chart+accumulation+(2).jpg

I hope it helped!

View solution in original post

Not applicable
Author

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