Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
andy
Partner - Creator III
Partner - Creator III

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

andy
Partner - Creator III
Partner - Creator III
Author

Thanks,

Fast and correct!

/Andy