Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
danimarc12
Partner
Partner

Conditional expression with sub

Hello everyone!

I have an issue with an expression. I want to calculate the AVG of field1 - field2 with the condition that field1-field2 < 1.

this is my expression:

avg({<"$(=approvatoData-dataOrdineEora < 1)">}approvatoData-dataOrdineEora)

of course it doesn't work. Can anyone help me to write it correct and the reason of the correct method?

Thank you all!

1 Reply
danimarc12
Partner
Partner
Author

PS. approvatoData and dataOrdineEora are two datetime fields