topic Condition in Expression in QlikView

Condition in Expression

sushil353 — Mon, 13 Jun 2011 10:09:19 GMT

Hi All,

I have 2 fields in a same table

Field 1: Unit_ID

Field 2: Status

Unit_ID gives the unit id's processed in the plant.

and status give the various status of the operation applied on the perticular unit. status are PASS,FAIL,ERROR

I want to calculate the no of units for which the status is PASS.

Please suggest me the expression for that.

Thanks

Mon, 13 Jun 2011 10:14:08 GMT

Hi,

You can achieve this using set analysis

count({<Status={'PASS'}>} Unit_ID)

neetu_singh — Mon, 13 Jun 2011 10:17:52 GMT

Hi,

Please find the attachment.

Regards

Neetu Singh

Mon, 13 Jun 2011 10:23:19 GMT

U can also use:

Expression:

COUNT(if(Status='PASS',[Unit Id]))

sushil353 — Mon, 13 Jun 2011 10:31:32 GMT

Thanks Shans My problem is solved