topic Re: Front End Expression in QlikView

Front End Expression

kiranpatil123 — Sat, 16 Nov 2024 18:57:56 GMT

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

Re: Front End Expression

rubenmarin — Wed, 11 Mar 2020 09:06:38 GMT

Hi, you can try with:

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

Re: Front End Expression

kiranpatil123 — Wed, 11 Mar 2020 13:27:33 GMT

Thanks a lot @rubenmarin . It Worked