Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
You can achieve this using set analysis
Please find the attachment.
U can also use:
Thanks Shans My problem is solved