Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aresb
Creator
Creator

sum over a dimension (YTD CALC)

Hi everyone,

 

i have this table

id_date des_time_chiamate cod_connid_3
01/01/2020 8 1
01/01/2020 9 1
01/01/2020 10 4
01/01/2020 11 4
01/01/2020 12 4
01/01/2020 13 7
01/01/2020 14 10
01/01/2020 15 6
01/01/2020 16 5
01/01/2020 17 8
01/01/2020 18 9
02/01/2020 8 10
02/01/2020 9 9
02/01/2020 10 8
02/01/2020 11 8
02/01/2020 12 5
02/01/2020 13 5
02/01/2020 14 7
02/01/2020 15 2
02/01/2020 16 9
02/01/2020 17 9
02/01/2020 18 9
03/01/2020 8 1
03/01/2020 9 9
03/01/2020 10 2
03/01/2020 11 4
03/01/2020 12 2
03/01/2020 13 6
03/01/2020 14 8
03/01/2020 15 1
03/01/2020 16 7
03/01/2020 17 5
03/01/2020 18 5
01/02/2020 8 10
01/02/2020 9 8
01/02/2020 10 1
01/02/2020 11 9
01/02/2020 12 6
01/02/2020 13 5
01/02/2020 14 4
01/02/2020 15 1
01/02/2020 16 2
01/02/2020 17 8
01/02/2020 18

4

 

If i filter on february 2020 i need to sum a YTD calculation over des_time_chiamate having a table like this, including jan 2020.

des_time_chiamate                                                                         (YTD_cod_connid_3)

8 27
9 24
10 27
11 36
12 24
13 29
14 36
15 30
16 29
17 38
18 36

 




How can i achieve this ? 

 

Thank You in advance

 

 

 

Labels (3)
2 Replies
G3S
Creator III
Creator III

Is that the expected result you are showing in the 2nd table? are you able to share that calculation

aresb
Creator
Creator
Author

Hi, g3s

yes im expecting that result.

sum({<des_time_chiamate={">=$(=Min(des_time_chiamate))<=$(=Max((des_time_chiamate)))"}>}cod_connid_3)