Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

Condition in Expression

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

1 Solution

Accepted Solutions
Not applicable

Condition in Expression

Hi,

You can achieve this using set analysis

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

4 Replies
Not applicable

Condition in Expression

Hi,

You can achieve this using set analysis

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

neetu_singh
Contributor III

Re: Condition in Expression

Hi,

Please find the attachment.

Regards

Neetu Singh

Not applicable

Condition in Expression

U can also use:

Expression:

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

sushil353
Honored Contributor II

Condition in Expression

Thanks Shans My problem is solved

Community Browser