https://community.qlik.com/t5/App-Development/Conditional-expression-with-sub/m-p/1838206#M69304 <P>PS<STRONG>. approvatoData&nbsp;</STRONG>and <STRONG>dataOrdineEora&nbsp;</STRONG>are two datetime fields</P> Wed, 22 Sep 2021 07:05:34 GMT danimarc12 2021-09-22T07:05:34Z https://community.qlik.com/t5/App-Development/Conditional-expression-with-sub/m-p/1838202#M69303 <P>Hello everyone!</P><P>I have an issue with an expression. I want to calculate the AVG of field1 - field2 with the condition that field1-field2 &lt; 1.</P><P>this is my expression:</P><P><STRONG>avg({&lt;"$(=approvatoData-dataOrdineEora &lt; 1)"&gt;}approvatoData-dataOrdineEora)</STRONG></P><P>of course it doesn't work. Can anyone help me to write it correct and the reason of the correct method?</P><P>Thank you all!</P> Wed, 22 Sep 2021 07:02:11 GMT https://community.qlik.com/t5/App-Development/Conditional-expression-with-sub/m-p/1838202#M69303 danimarc12 2021-09-22T07:02:11Z https://community.qlik.com/t5/App-Development/Conditional-expression-with-sub/m-p/1838206#M69304 <P>PS<STRONG>. approvatoData&nbsp;</STRONG>and <STRONG>dataOrdineEora&nbsp;</STRONG>are two datetime fields</P> Wed, 22 Sep 2021 07:05:34 GMT https://community.qlik.com/t5/App-Development/Conditional-expression-with-sub/m-p/1838206#M69304 danimarc12 2021-09-22T07:05:34Z