Bar chart of accumulated values ​​from a specific date with the previous accumulated data

[BS]

Hi everyone,

I have a bar chart of accumulated values ​​from the data source as you can see in the image below:

Now I need to show only from a specific date, for example, "5/2019" as in the following image

When I write the function so that it shows the values ​​from this date, Qlik shows only the accumulated values ​​FROM that date but it does not show the PREVIOUS accumulated values ​​as in the second attached photo.

Anyone knows if this is possible?

I hope I have expressed myself correctly 🙂

[azertyh]

hello,

i have the same request so im very interested how it can be done.

[kaanerisen · Accepted solution]

Hi BS,

You can achieve taht by using aggr function with rangesum. But you should use set analysis in your expression not to affected by dimension you use.

Sample Script:

SampleData:
load * Inline [
MONTH,VALUE
1,300
2,100
3,200
4,200
5,400
6,100
7,500
8,300
9,200
10,400
11,400
12,300
];

Dimension : MONTH

Mesaure : AGGR(RANGESUM(ABOVE(SUM({<MONTH=>}VALUE),0,RowNo())),MONTH)

Full Data:

Full Data

Filtered Data:Filtered Data

Hope it helps..

[BS]

That worked perfectly, thank you so much!