Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
inam
Contributor III
Contributor III

excel formula in qlikview

Hello Community

I need this Excel  formula in QlikView. 

excel formula :-    =IFERROR(1/COUNTIF([File No.],[@[File No.]]),0)

I am trying  this IF(COUNT([File No.]) > 0, 1 / COUNT({< [File No.] = {"$(= [File No.])"} >}), 0)  in script(backend)But its show error.

how I use this excel formula in Expression also( front end) .

Labels (3)
0 Replies