Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart - Dimension Limits & Accumulation

Hello!

I have the following example table:

DateYDateQAmount
2014Q310
2014Q45
2015Q10
2015Q220
2015Q315

If I want to create an accumulative bar chart that only shows 2015 but instead of starting at 0, I would like it to start at the sum of the previous dates (15 in this case).


What I also experimented with is to load the entire dataset and limit the dimension, but it doesn't have an option to limit the last x amount of values, only the first and I can't figure out how to position the Other bucket at the beginning.


Thanks in advance!


-Jason

3 Replies
Not applicable
Author

can you use the Scale settings for min (for either your dimentsion or expression) and have the min be your expression containing the total for the prior year?

Gysbert_Wassenaar

Can you post the result table you expect using your example data?

If you want to do accumulation perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
marcus_sommer

Maybe something like this:

if(DateY = 2015 and DateQ = 1,

     rangesum(sum({1< DateY = {2014}>} Amount), above(sum(Amount), 0, rowno(total))),

     rangesum(above(sum(Amount), 0, rowno(total))))

- Marcus