If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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 🙂
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..
hello,
i have the same request so im very interested how it can be done.
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..
That worked perfectly, thank you so much!