Monthly trend line in Line chart

jkin — Sat, 16 Nov 2024 02:15:39 GMT

I have a line chart that is sum of values per date (line chart image)

Data example looks like this:

id       date         volume 
----------------------------
1      11/12/2019     203.1
2      11/12/2019     198.0
3      11/12/2019     209.0

which I have computed sum in Qlik and have following example data format for the line chart above:

date          sum 
--------------------
11/12/2019   610.1
11/17/2019   543.2
11/20/2019   550.8
11/30/2019   256.7
12/1/2019    1042
12/2/2019    885.1
12/4/2019    635.8
12/7/2019    967.4
12/10/2019   1011.3

I'd like to add a monthly trend line to make the trend look more obvious. So, for the example above, I want lines of November and December to have values of 490.2 and 908.3, respectively.

However, I can't figure out how to add measure that will compute the average of sum of values for that month and add a horizontal trend line for that month.

I found few posts on Qlik community and someone had suggested to use `sum(total <month> volume)/count(distinct total <month> date` , but <month> thing which he seemed to have used to add as conditional statement doesn't work for me somehow, even after I create master dimension/measure for month time frame. Any help would be appreciated.

topic Monthly trend line in Line chart in App Development

Monthly trend line in Line chart