topic Count row in table in QlikView

Count row in table

Anonymous — Sun, 11 Jun 2017 06:22:29 GMT

I have table with fields and varibles.

I try to calculate two things:

1. Count only Pass rows ( Pass is varible, not a field)

2. Count all table rows.

I try using Aggr function but its not accruate...

Any idea?

Thanks

Ravit

sunny_talwar — Sun, 11 Jun 2017 06:55:19 GMT

What is the expression for Pass/Fail in the table or is this a field from the script?

Anonymous — Sun, 11 Jun 2017 07:01:07 GMT

the expression in if statemnet that include more varibles

sunny_talwar — Sun, 11 Jun 2017 07:03:06 GMT

What is it though?

Anonymous — Sun, 11 Jun 2017 07:25:34 GMT

for example:

if (ParamID=303 or (AVG(AVG_Val)=-1) or IsNull(ReportParamName),'Fail',

if (DashboardID=6 or DashboardID=7 or ParamID=120 or ParamID=121,$(v4Pass),

if (ParamID=781 ,$(vFairnessPass),

$(v3Result))))