Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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