Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor

How to summarize a calculated field in which a variable has been used...


Per loaded record (stock mutations) I defined a field called 'TimePeriod' in which I typed the following expression:

If( (vToday - Num( date_mutation)) <= $(nb_of_days_variable), mutation_quantity)

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.

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.

I hope somebody has a solution for this issue ?

Thank you in advance.



Community Browser