Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

If 'Part' is in 'TYPE1' and 'Part' must be in both 'Wire1' and 'Wire2'. I want to display the value

I have a field 'TYPE' , 'Wire ' , 'Output ' ,'Part',  'Number'

in field  'TYPE' contains data  'TYPE1' and 'TYPE2'

in field  'Wire' contains data  'Wire1' and 'Wire2'

 

I want to display the value 'Output *'Number' 

If 'Part' is in 'TYPE1' and 'Part' must be in both 'Wire1' and 'Wire2'.

I tried this code but the value is incorrect:

(Sum({<Wire={'Wire1'},Wire={'Wire2'}, TYPE={'TYPE1'}>} Aggr((Output *'Number),Part,,WorkOrderNo)))

 

0 Replies