Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mcoolen01
Contributor
Contributor

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

Hello,

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.

Greetings,

Michel

0 Replies