Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

If any WorkOrder has 'NOT PASS', show the WorkOrder that is both 'PASS' and 'NOT PASS'.

I haev field : WorkOrder , TYPE

Sxbbb_0-1700451380630.png

I want to display 'WorkOrder' that has'TYPE '=  NOT PASS. 

If any WorkOrder has 'NOT PASS', show the WorkOrder that is both 'PASS' and 'NOT PASS'.

 

 

EX  WorkOrder ='A0204574-01-102'  that are both 'PASS' and 'NOT PASS' must show all ='A0204574-01-102'  details.

Sxbbb_1-1700451757384.png

 

3 Replies
justISO
Specialist
Specialist

Hi, as one dummy workaround would be something like this:

=if(index(aggr(concat(distinct FA_Pass), WorkOrderNo), 'NOT')>0, WorkOrderNo)

and exclude (not show) null values.

Sxbbb
Creator III
Creator III
Author

Thank you very much.

Sxbbb
Creator III
Creator III
Author

I want to display FA_Pass = 'NOT PASS'  QTYPCS has only the largest value. 

EX  NOT PASS show at FA Code Reject = TC18

Sxbbb_0-1701828347372.png