Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mini chart in straight table will not accumulate

Hi

I have googled up and down to see if there are any solutions to this issue, but it seems like there isn't.

I have a straight table where I'd like to show YTD graph line, and I want it to be accumulated. And as all sales are positive numbers it's easy to see that the line always should go sideways or upwards.  But the build in "Full Accumulation" does not work in this case, and as far as I could find information it might have to do with me having one dimension for the straight table "Country", and another for the minichart "Month".

Adding many separate charts and just make them smaller without axis is a possible, but not good workaround as I lose quite a lot of the flexibility that is one of the mainthings about Qlikview. So I'm really hopeing to find a way of using an expression to do this.

Are there anyone out here that would know how to solve this, or is it not possible?

Kind regards

Espen

1 Reply
Gysbert_Wassenaar

It's possible. You can use an AsOf table as explained in this document: Calculating rolling n-period totals, averages or other aggregations. You can find an example on Sheet1 of the attached qvw.


talk is cheap, supply exceeds demand