Front End Expression

[kiranpatil123]

Hi All 

Attached is the excel File for Logic explanation

Column C , D & E are derived measures in Qlikview  .

I need the count of Column C where column C > 0 ( leaving blanks in excel )and the sum of Column D and E that is 66 and filter out sum where it is >0 , ie the count is 44 ( i need this count number ) , How do i achieve in front End ?

Please help.

Advance Thanks 

[rubenmarin · Accepted solution]

Hi, you can try with:

=Count({<Scanner={"*"}, ID={"=RangeSum(ISP,ICAP)>0"}>} ID)

[kiranpatil123]

Thanks a lot @rubenmarin  . It Worked