https://community.qlik.com/t5/App-Development/AVG-and-IF-formula/m-p/1897193#M74058 <P>Hi,</P> <P>&nbsp;I wanted to use Avg and IF conditions together in the visualization table.</P> <P>If Dgroup = d1,d2,d3,d4,d5 then only calculate in column Avg(first arrival time - incident timestamp)</P> <P>Can anyone suggest?</P> <P>&nbsp;</P> <P>Thank You,</P> <P>Dhruvi</P> Thu, 24 Feb 2022 14:44:42 GMT dhruvipanchal88 2022-02-24T14:44:42Z https://community.qlik.com/t5/App-Development/AVG-and-IF-formula/m-p/1897193#M74058 <P>Hi,</P> <P>&nbsp;I wanted to use Avg and IF conditions together in the visualization table.</P> <P>If Dgroup = d1,d2,d3,d4,d5 then only calculate in column Avg(first arrival time - incident timestamp)</P> <P>Can anyone suggest?</P> <P>&nbsp;</P> <P>Thank You,</P> <P>Dhruvi</P> Thu, 24 Feb 2022 14:44:42 GMT https://community.qlik.com/t5/App-Development/AVG-and-IF-formula/m-p/1897193#M74058 dhruvipanchal88 2022-02-24T14:44:42Z https://community.qlik.com/t5/App-Development/AVG-and-IF-formula/m-p/1897288#M74074 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/166267">@dhruvipanchal88</a>&nbsp;, Can you please provide some sample data and output expected.</P> Thu, 24 Feb 2022 17:08:15 GMT https://community.qlik.com/t5/App-Development/AVG-and-IF-formula/m-p/1897288#M74074 Iswarya_ 2022-02-24T17:08:15Z