Aggregate the values for each month in line chart instead of individual points
Hello Gurus,
I am facing a issue in Qlik Line chart. I have mentioned data:
Country
Date
Value
India
01-01-2020
10
India
02-01-2020
17
India
03-01-2020
14
India
04-01-2020
20
India
01-02-2020
13
India
02-02-2020
11
India
03-02-2020
12
India
04-02-2020
11
India
01-03-2020
20
India
02-03-2020
11
India
03-03-2020
11
India
04-03-2020
15
India
01-04-2020
15
India
02-04-2020
11
India
03-04-2020
11
India
04-04-2020
12
Germany
01-01-2020
11
Germany
02-01-2020
11
Germany
03-01-2020
13
Germany
04-01-2020
18
Germany
01-02-2020
11
Germany
02-02-2020
11
Germany
03-02-2020
11
Germany
04-02-2020
18
Germany
01-03-2020
11
Germany
02-03-2020
18
Germany
03-03-2020
20
Germany
04-03-2020
14
Germany
01-04-2020
20
Germany
02-04-2020
16
Germany
03-04-2020
14
Germany
04-04-2020
10
Italy
01-01-2020
15
Italy
02-01-2020
14
Italy
03-01-2020
20
Italy
04-01-2020
16
Italy
01-02-2020
16
Italy
02-02-2020
16
Italy
03-02-2020
12
Italy
04-02-2020
11
Italy
01-03-2020
20
Italy
02-03-2020
17
Italy
03-03-2020
20
Italy
04-03-2020
19
Italy
01-04-2020
12
Italy
02-04-2020
10
Italy
03-04-2020
19
Italy
04-04-2020
11
So what I want to see in line chart is basically the trend of values for each month. But below is the output I am getting. Instead of getting cumulative value for each month, the data is getting plotted for each date. Basically I need only one point for each month instead of 4.
For months I want to see only past 3 month trend from the selected month. Below is the expression I am using but somehow it does'nt work: