Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
sum({<Date={">=$(=addmonths(max(Date),-2))<=$(=addmonths(max(Date),0))"}>}Value)
Any help here would be highly appreciated.