Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Front End Expression

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 

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

Hi, you can try with:

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

View solution in original post

2 Replies
rubenmarin

Hi, you can try with:

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

View solution in original post

kiranpatil123
Contributor III
Contributor III
Author

Thanks a lot @rubenmarin  . It Worked