Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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