topic Aggregate the values for each month in line chart instead of individual points in App Development https://community.qlik.com/t5/App-Development/Aggregate-the-values-for-each-month-in-line-chart-instead-of/m-p/1767687#M59382 <P>Hello Gurus,</P><P>I am facing a issue in Qlik Line chart. I have mentioned data:</P><TABLE><TBODY><TR><TD>Country</TD><TD>Date</TD><TD>Value</TD></TR><TR><TD>India</TD><TD>01-01-2020</TD><TD>10</TD></TR><TR><TD>India</TD><TD>02-01-2020</TD><TD>17</TD></TR><TR><TD>India</TD><TD>03-01-2020</TD><TD>14</TD></TR><TR><TD>India</TD><TD>04-01-2020</TD><TD>20</TD></TR><TR><TD>India</TD><TD>01-02-2020</TD><TD>13</TD></TR><TR><TD>India</TD><TD>02-02-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-02-2020</TD><TD>12</TD></TR><TR><TD>India</TD><TD>04-02-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>01-03-2020</TD><TD>20</TD></TR><TR><TD>India</TD><TD>02-03-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-03-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>04-03-2020</TD><TD>15</TD></TR><TR><TD>India</TD><TD>01-04-2020</TD><TD>15</TD></TR><TR><TD>India</TD><TD>02-04-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-04-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>04-04-2020</TD><TD>12</TD></TR><TR><TD>Germany</TD><TD>01-01-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-01-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>03-01-2020</TD><TD>13</TD></TR><TR><TD>Germany</TD><TD>04-01-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>01-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>03-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>04-02-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>01-03-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-03-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>03-03-2020</TD><TD>20</TD></TR><TR><TD>Germany</TD><TD>04-03-2020</TD><TD>14</TD></TR><TR><TD>Germany</TD><TD>01-04-2020</TD><TD>20</TD></TR><TR><TD>Germany</TD><TD>02-04-2020</TD><TD>16</TD></TR><TR><TD>Germany</TD><TD>03-04-2020</TD><TD>14</TD></TR><TR><TD>Germany</TD><TD>04-04-2020</TD><TD>10</TD></TR><TR><TD>Italy</TD><TD>01-01-2020</TD><TD>15</TD></TR><TR><TD>Italy</TD><TD>02-01-2020</TD><TD>14</TD></TR><TR><TD>Italy</TD><TD>03-01-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>04-01-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>01-02-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>02-02-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>03-02-2020</TD><TD>12</TD></TR><TR><TD>Italy</TD><TD>04-02-2020</TD><TD>11</TD></TR><TR><TD>Italy</TD><TD>01-03-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>02-03-2020</TD><TD>17</TD></TR><TR><TD>Italy</TD><TD>03-03-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>04-03-2020</TD><TD>19</TD></TR><TR><TD>Italy</TD><TD>01-04-2020</TD><TD>12</TD></TR><TR><TD>Italy</TD><TD>02-04-2020</TD><TD>10</TD></TR><TR><TD>Italy</TD><TD>03-04-2020</TD><TD>19</TD></TR><TR><TD>Italy</TD><TD>04-04-2020</TD><TD>11</TD></TR></TBODY></TABLE><P>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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saurabh07_0-1607617155963.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45528i11146FEE10CA4A85/image-size/medium?v=v2&amp;px=400" role="button" title="Saurabh07_0-1607617155963.png" alt="Saurabh07_0-1607617155963.png" /></span></P><P>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:</P><P>sum({&lt;Date={"&gt;=$(=addmonths(max(Date),-2))&lt;=$(=addmonths(max(Date),0))"}&gt;}Value)</P><P>Any help here would be highly appreciated.</P><P>&nbsp;</P> Mon, 20 Dec 2021 21:08:46 GMT Saurabh07 2021-12-20T21:08:46Z Aggregate the values for each month in line chart instead of individual points https://community.qlik.com/t5/App-Development/Aggregate-the-values-for-each-month-in-line-chart-instead-of/m-p/1767687#M59382 <P>Hello Gurus,</P><P>I am facing a issue in Qlik Line chart. I have mentioned data:</P><TABLE><TBODY><TR><TD>Country</TD><TD>Date</TD><TD>Value</TD></TR><TR><TD>India</TD><TD>01-01-2020</TD><TD>10</TD></TR><TR><TD>India</TD><TD>02-01-2020</TD><TD>17</TD></TR><TR><TD>India</TD><TD>03-01-2020</TD><TD>14</TD></TR><TR><TD>India</TD><TD>04-01-2020</TD><TD>20</TD></TR><TR><TD>India</TD><TD>01-02-2020</TD><TD>13</TD></TR><TR><TD>India</TD><TD>02-02-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-02-2020</TD><TD>12</TD></TR><TR><TD>India</TD><TD>04-02-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>01-03-2020</TD><TD>20</TD></TR><TR><TD>India</TD><TD>02-03-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-03-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>04-03-2020</TD><TD>15</TD></TR><TR><TD>India</TD><TD>01-04-2020</TD><TD>15</TD></TR><TR><TD>India</TD><TD>02-04-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>03-04-2020</TD><TD>11</TD></TR><TR><TD>India</TD><TD>04-04-2020</TD><TD>12</TD></TR><TR><TD>Germany</TD><TD>01-01-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-01-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>03-01-2020</TD><TD>13</TD></TR><TR><TD>Germany</TD><TD>04-01-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>01-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>03-02-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>04-02-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>01-03-2020</TD><TD>11</TD></TR><TR><TD>Germany</TD><TD>02-03-2020</TD><TD>18</TD></TR><TR><TD>Germany</TD><TD>03-03-2020</TD><TD>20</TD></TR><TR><TD>Germany</TD><TD>04-03-2020</TD><TD>14</TD></TR><TR><TD>Germany</TD><TD>01-04-2020</TD><TD>20</TD></TR><TR><TD>Germany</TD><TD>02-04-2020</TD><TD>16</TD></TR><TR><TD>Germany</TD><TD>03-04-2020</TD><TD>14</TD></TR><TR><TD>Germany</TD><TD>04-04-2020</TD><TD>10</TD></TR><TR><TD>Italy</TD><TD>01-01-2020</TD><TD>15</TD></TR><TR><TD>Italy</TD><TD>02-01-2020</TD><TD>14</TD></TR><TR><TD>Italy</TD><TD>03-01-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>04-01-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>01-02-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>02-02-2020</TD><TD>16</TD></TR><TR><TD>Italy</TD><TD>03-02-2020</TD><TD>12</TD></TR><TR><TD>Italy</TD><TD>04-02-2020</TD><TD>11</TD></TR><TR><TD>Italy</TD><TD>01-03-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>02-03-2020</TD><TD>17</TD></TR><TR><TD>Italy</TD><TD>03-03-2020</TD><TD>20</TD></TR><TR><TD>Italy</TD><TD>04-03-2020</TD><TD>19</TD></TR><TR><TD>Italy</TD><TD>01-04-2020</TD><TD>12</TD></TR><TR><TD>Italy</TD><TD>02-04-2020</TD><TD>10</TD></TR><TR><TD>Italy</TD><TD>03-04-2020</TD><TD>19</TD></TR><TR><TD>Italy</TD><TD>04-04-2020</TD><TD>11</TD></TR></TBODY></TABLE><P>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.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saurabh07_0-1607617155963.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/45528i11146FEE10CA4A85/image-size/medium?v=v2&amp;px=400" role="button" title="Saurabh07_0-1607617155963.png" alt="Saurabh07_0-1607617155963.png" /></span></P><P>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:</P><P>sum({&lt;Date={"&gt;=$(=addmonths(max(Date),-2))&lt;=$(=addmonths(max(Date),0))"}&gt;}Value)</P><P>Any help here would be highly appreciated.</P><P>&nbsp;</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Aggregate-the-values-for-each-month-in-line-chart-instead-of/m-p/1767687#M59382 Saurabh07 2021-12-20T21:08:46Z