https://community.qlik.com/t5/App-Development/Sum-of-value/m-p/1670525#M50671 <P>Hello All,</P><P>I have categories which has values for each date. I need to sum up the total of category 1 category 2 and category 3 depending on the data range.</P><P>For example:</P><P>Category 3 has the starting date as 2019-07-09 and has a value 458. Now i want to pick the values from the category 1, 2 , 3 by considering the starting date of category 3. Here i need to pick the values of category 1 and 2 having the date range &lt;= 2019-07-09. Please can someone let me know how to achieve this .</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Category 1</TD><TD>Category 2</TD><TD>Category 2</TD><TD>Category 3</TD><TD>Category 3</TD><TD>Category 3</TD><TD>Category 4</TD><TD>Category 4</TD><TD>Category 4</TD></TR><TR><TD>2019-06-28</TD><TD>2019-07-01</TD><TD>2019-07-02</TD><TD>2019-07-09</TD><TD>2019-07-10</TD><TD>2019-07-11</TD><TD>2019-07-16</TD><TD>2019-07-17</TD><TD>2019-07-18</TD></TR><TR><TD>12</TD><TD>14</TD><TD>15</TD><TD>458</TD><TD>871</TD><TD>1284</TD><TD>2523</TD><TD>2936</TD><TD>3349</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">Total I need&nbsp;</FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>499</TD><TD>1370</TD><TD>2654</TD><TD>5136</TD><TD>8072</TD><TD>11421</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P> Mon, 20 Dec 2021 21:38:40 GMT dandaanilreddy 2021-12-20T21:38:40Z https://community.qlik.com/t5/App-Development/Sum-of-value/m-p/1670525#M50671 <P>Hello All,</P><P>I have categories which has values for each date. I need to sum up the total of category 1 category 2 and category 3 depending on the data range.</P><P>For example:</P><P>Category 3 has the starting date as 2019-07-09 and has a value 458. Now i want to pick the values from the category 1, 2 , 3 by considering the starting date of category 3. Here i need to pick the values of category 1 and 2 having the date range &lt;= 2019-07-09. Please can someone let me know how to achieve this .</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Category 1</TD><TD>Category 2</TD><TD>Category 2</TD><TD>Category 3</TD><TD>Category 3</TD><TD>Category 3</TD><TD>Category 4</TD><TD>Category 4</TD><TD>Category 4</TD></TR><TR><TD>2019-06-28</TD><TD>2019-07-01</TD><TD>2019-07-02</TD><TD>2019-07-09</TD><TD>2019-07-10</TD><TD>2019-07-11</TD><TD>2019-07-16</TD><TD>2019-07-17</TD><TD>2019-07-18</TD></TR><TR><TD>12</TD><TD>14</TD><TD>15</TD><TD>458</TD><TD>871</TD><TD>1284</TD><TD>2523</TD><TD>2936</TD><TD>3349</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><FONT color="#FF0000">Total I need&nbsp;</FONT></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>499</TD><TD>1370</TD><TD>2654</TD><TD>5136</TD><TD>8072</TD><TD>11421</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks</P> Mon, 20 Dec 2021 21:38:40 GMT https://community.qlik.com/t5/App-Development/Sum-of-value/m-p/1670525#M50671 dandaanilreddy 2021-12-20T21:38:40Z