LOAD * INLINE [age contact
24 unknown] (delimiter is ' ');
left join (Sample)
, if(match(concat(contact,','),'cellular,telephone,unknown'),1,0) as _Flag_All_Contact
Group By age
Order by age,contact Asc
Now you can use _Flag_All_Contact in your expression.
If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply.