Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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)

View solution in original post

Partner
Partner

Hi,

Please find the attachment.

Regards

Neetu Singh

Not applicable

U can also use:

Expression:

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

Master II
Master II

Thanks Shans My problem is solved