Include data outside app/chart filters

Qlik87 — Sat, 16 Nov 2024 06:48:12 GMT

Hi,

Apologies if I've missed a topic, but I have a question about cumulative figures in charts.

I am trying to show my stakeholders how much work they have, this needs to add up cumulatively, but as soon as i select a year or month the calculation defaults to the first value.

In the example data below when I click 2018, the calculation restarts at 10, but I need to show 88. Business rules mean I have to show 88 because that is what we worked on in Jan 2018.

Data:

Date	Opened	Closed	Cumu.Open	Cumu. Close
2017-01	2	0	2	0
2017-02	4	0	6	0
2017-03	6	0	12	0
2017-04	6	3	18	3
2017-05	6	3	24	6
2017-06	6	4	30	10
2017-07	6	5	36	15
2017-08	8	9	44	24
2017-09	8	11	52	35
2017-10	8	12	60	47
2017-11	8	10	68	57
2017-12	10	11	78	68
2018-01	10	15	88	83
2018-02	10	19	98	102
2018-03	12	20	110	122
2018-04	10	6	120	128
2018-05	8	6	128	134
2018-06	8	6	136	140
2018-07	6	4	142	144
2018-08	10	2	152	146
2018-09	6	10	158	156
2018-10	8	6	166	162
2018-11	2	6	168	168
2018-12	4	2	172	170

I'd like to do this in the chart as I've lots of departments to drill down through and decades of data so creating a new table would be cumbersome. Ideally I want to reference my charts dimension and showing something like "count if <= dimesion", with the filter only affect the axis shown and not the underlying data.

Any ideas would be grateful,

Andrew

topic Include data outside app/chart filters in App Development

Include data outside app/chart filters