topic How to summarize a calculated field in which a variable has been used... in App Development https://community.qlik.com/t5/App-Development/How-to-summarize-a-calculated-field-in-which-a-variable-has-been/m-p/1338879#M29458 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Per loaded record (stock mutations) I defined a field called 'TimePeriod' in which I typed the following expression:</P><P></P><P><STRONG>If( (vToday - Num( date_mutation)) &lt;= $(nb_of_days_variable), mutation_quantity)</STRONG></P><P></P><P>The result of this expression shows me the mutation_quantity per record if the difference between today and the mutation_date is smaller or equal than the number of day's I put into my variable (using a slider in the frontend). So far, so good.</P><P></P><P>What I now would like to do is summarize the field 'TimePeriod' per product in an other table within the same sheet but I do not know how to fix this.</P><P></P><P>I hope somebody has a solution for this issue ?</P><P></P><P>Thank you in advance.</P><P>Greetings,</P><P>Michel</P></BODY></HTML> Fri, 12 May 2017 17:19:48 GMT mcoolen01 2017-05-12T17:19:48Z How to summarize a calculated field in which a variable has been used... https://community.qlik.com/t5/App-Development/How-to-summarize-a-calculated-field-in-which-a-variable-has-been/m-p/1338879#M29458 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Per loaded record (stock mutations) I defined a field called 'TimePeriod' in which I typed the following expression:</P><P></P><P><STRONG>If( (vToday - Num( date_mutation)) &lt;= $(nb_of_days_variable), mutation_quantity)</STRONG></P><P></P><P>The result of this expression shows me the mutation_quantity per record if the difference between today and the mutation_date is smaller or equal than the number of day's I put into my variable (using a slider in the frontend). So far, so good.</P><P></P><P>What I now would like to do is summarize the field 'TimePeriod' per product in an other table within the same sheet but I do not know how to fix this.</P><P></P><P>I hope somebody has a solution for this issue ?</P><P></P><P>Thank you in advance.</P><P>Greetings,</P><P>Michel</P></BODY></HTML> Fri, 12 May 2017 17:19:48 GMT https://community.qlik.com/t5/App-Development/How-to-summarize-a-calculated-field-in-which-a-variable-has-been/m-p/1338879#M29458 mcoolen01 2017-05-12T17:19:48Z