Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
BS
Contributor III
Contributor III

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
Creator III
Creator III

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 DataFull Data

Filtered Data:Filtered DataFiltered Data

Hope it helps..

View solution in original post

3 Replies
azertyh
Contributor II
Contributor II

hello,

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

kaanerisen
Creator III
Creator III

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 DataFull Data

Filtered Data:Filtered DataFiltered Data

Hope it helps..

View solution in original post

BS
Contributor III
Contributor III
Author

That worked perfectly, thank you so much!