QlikView Set analysis

[AS_A]

Hello,

Could you please help me to convert the below if condition to set expression? I'm also facing calculation timed out or out of memory issue.

if((if(Len(trim(field1))>0 and Len(trim(field2))>0, (AGGR(NODISTINCT(if(field3 = field4, output)),field3,field4,field2)),'N/A'))>0,

(if(Len(trim([field1))>0,(AGGR(NODISTINCT(if(field3= field4,output)),,field3,field4,field2)),'N/A')),'N/A').

Thank you 🙂

[Lisa_P]

Can you please explain the result you are trying to achieve.

[marcus_sommer]

It seems that your data-model isn't suitable for this kind of query and the included fields have no respectively no proper association and the aggr() creates now some kind of cartesian product. Further all conditions are directly related to field-values and therefore they could be resolved within the script by creating one and/or several flag-fields.

[Butler23]

Is there any conclusion?

- Cuyahoga County Auditor