Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BS
New Contributor II

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

Hi everyone,

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

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

Total acumulado desde fecha.jpg

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 🙂

 

1 Solution

Accepted Solutions
kaanerisen
Contributor III

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

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:

Untitled.pngFull Data

Filtered Data:Untitled1.pngFiltered Data

Hope it helps..

3 Replies
azertyh
New Contributor II

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

hello,

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

kaanerisen
Contributor III

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

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:

Untitled.pngFull Data

Filtered Data:Untitled1.pngFiltered Data

Hope it helps..

BS
New Contributor II

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

That worked perfectly, thank you so much!