Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andy
Partner
Partner

Having accumulated values, how to get it per month from Accesspoint?

Hi folks,

I know that the answer is to take the values for a month minus the values for the previous month but since doing this in the load-script is not an option how can it be done by a power-user only having the existing QV-document to play with on the accesspoint?

The end result shall be a bar-chart with the month as dimension and isolated values per month as values.

Since set-analysis is just evaluated once per object that won't work.

Example

Having this

Month     AccValue

2012-9       800

2012-10     900     

2012-11    1100    

2012-12     900     

2013-1     1000     

2013-2     1100     

...

Wanting this

Month      MonthValue

2012-9

2012-10      100

2012-11      200

2012-12      200

2013-1        100

2013-2        100

brgds

Andy

1 Solution

Accepted Solutions
Damian_Waldron
Employee
Employee

why not use the Above Function?

Have a look at this thread which provides a qvw for above and accumulation.

http://community.qlik.com/thread/12711

View solution in original post

2 Replies
Damian_Waldron
Employee
Employee

why not use the Above Function?

Have a look at this thread which provides a qvw for above and accumulation.

http://community.qlik.com/thread/12711

View solution in original post

andy
Partner
Partner
Author

Thanks,

Fast and correct!

/Andy