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.
![Saurabh07_0-1607617155963.png Saurabh07_0-1607617155963.png](https://community.qlik.com/t5/image/serverpage/image-id/45528i11146FEE10CA4A85/image-size/medium?v=v2&px=400)
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:
sum({<Date={">=$(=addmonths(max(Date),-2))<=$(=addmonths(max(Date),0))"}>}Value)
Any help here would be highly appreciated.