topic Re: QlikView Set analysis in QlikView

QlikView Set analysis

AS_A — Fri, 15 Nov 2024 21:12:46 GMT

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 🙂

Re: QlikView Set analysis

Lisa_P — Wed, 13 Dec 2023 22:49:05 GMT

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

Re: QlikView Set analysis

marcus_sommer — Fri, 15 Dec 2023 08:05:24 GMT

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.

Re: QlikView Set analysis

Butler23 — Tue, 26 Dec 2023 10:37:48 GMT

Is there any conclusion?

- Cuyahoga County Auditor