Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master 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

Hi,

You can achieve this using set analysis

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

View solution in original post

4 Replies
Not applicable

Hi,

You can achieve this using set analysis

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

neetu_singh
Partner - Creator III
Partner - Creator III

Hi,

Please find the attachment.

Regards

Neetu Singh

Not applicable

U can also use:

Expression:

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

sushil353
Master II
Master II
Author

Thanks Shans My problem is solved