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

Compare 2 data in 2 columns then mark it Pass or Fail then count all Pass or Fail based location and testcode

Hello,

I have 2 columns named Minutes_Diff which is a result of a calculation(Ex: 5, 15, 16, 37 and etc). The 2nd colum named Target_Min is an Inline Load containing 5,10,15,20,25 up to 90 in increment of 5.

I want to add Target_Min to the a multi-box calls Selection Criterias so the user can decide which Target_Min to use in the comparision to Minutes_Diff.

If Target_Min selected is 15 then all records with Minutes_Diff greater(>) than 15 mark as Fail. All records with Minutes_Diff less then or equal to (<=) 15 mark as Pass

Then count all Fail and Pass group by location and test code.

Thank you.

0 Replies