Counting rows that meet a condition in a table

stvn_003 — Fri, 15 May 2015 16:26:02 GMT

Hello, I have a question, you can count the rows displayed in a table, and you can count the rows that meet a condition, in my case, all that in the "A" are zero

Already, thanks for the help

Re: Counting rows that meet a condition in a table

sunny_talwar — Fri, 15 May 2015 16:31:17 GMT

Count in a text box could be performed using the following expression:

=Sum(If(Aggr(Count({$<ocd_precio_ok = {N} >} ocd_cmtrlsap) - Count( {$<ocd_precio_ok = {N}, occ_fentr = {"<=$(=Date(Today()-7,'DD/MM/YYYY hh:m:ss tt'))"} >} ocd_cmtrlsap), ocd_cmtrlsap, ocd_tmtrlsap, occ_cgrsp) = 0, 1, 0))

HTH

Best,

Sunny

topic Counting rows that meet a condition in a table in QlikView

Counting rows that meet a condition in a table

Re: Counting rows that meet a condition in a table