https://community.qlik.com/t5/QlikView/excel-formula-in-qlikview/m-p/2074826#M1223780 <P>Hello Community</P> <P>I need this Excel&nbsp; formula in QlikView.&nbsp;</P> <P>excel formula :-&nbsp; &nbsp; <STRONG>=IFERROR(1/COUNTIF([File No.],[@[File No.]]),0)</STRONG></P> <P>I am trying&nbsp; this&nbsp;<STRONG>IF(COUNT([File No.]) &gt; 0, 1 / COUNT({&lt; [File No.] = {"$(= [File No.])"} &gt;}), 0)&nbsp;</STRONG> in script(backend)But its show error.</P> <P>how I use this excel formula in Expression also( front end) .</P> Wed, 24 May 2023 05:11:41 GMT inam 2023-05-24T05:11:41Z https://community.qlik.com/t5/QlikView/excel-formula-in-qlikview/m-p/2074826#M1223780 <P>Hello Community</P> <P>I need this Excel&nbsp; formula in QlikView.&nbsp;</P> <P>excel formula :-&nbsp; &nbsp; <STRONG>=IFERROR(1/COUNTIF([File No.],[@[File No.]]),0)</STRONG></P> <P>I am trying&nbsp; this&nbsp;<STRONG>IF(COUNT([File No.]) &gt; 0, 1 / COUNT({&lt; [File No.] = {"$(= [File No.])"} &gt;}), 0)&nbsp;</STRONG> in script(backend)But its show error.</P> <P>how I use this excel formula in Expression also( front end) .</P> Wed, 24 May 2023 05:11:41 GMT https://community.qlik.com/t5/QlikView/excel-formula-in-qlikview/m-p/2074826#M1223780 inam 2023-05-24T05:11:41Z