topic Re: Set Analysis in LookUp Function in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-in-LookUp-Function/m-p/863341#M657105 <HTML><HEAD></HEAD><BODY><P>You can't use set analysis in the load script. You'll have to use an if-statement.</P></BODY></HTML> Thu, 14 May 2015 16:32:16 GMT Gysbert_Wassenaar 2015-05-14T16:32:16Z Set Analysis in LookUp Function https://community.qlik.com/t5/QlikView/Set-Analysis-in-LookUp-Function/m-p/863340#M657104 <HTML><HEAD></HEAD><BODY><P>What is the syntax to add set analysis to the below statement? I do not want the lookup feature to operate if [Delivery No.] = 'Result' . I'm not sure how to incorporate that into the syntax.</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>date#<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">WeekEnd</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Lookup</SPAN><SPAN style="font-size: 8pt;">('Delivery_Date', 'Delivery_ID', </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Delivery No.]</SPAN><SPAN style="font-size: 8pt;">, 'Delivery_Date'), 0,2),'MM/DD/YYYY') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">'ActionDate' </SPAN></P><P> </P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;">Thank you for the help!</SPAN></P></BODY></HTML> Thu, 14 May 2015 16:02:02 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-in-LookUp-Function/m-p/863340#M657104 2015-05-14T16:02:02Z Re: Set Analysis in LookUp Function https://community.qlik.com/t5/QlikView/Set-Analysis-in-LookUp-Function/m-p/863341#M657105 <HTML><HEAD></HEAD><BODY><P>You can't use set analysis in the load script. You'll have to use an if-statement.</P></BODY></HTML> Thu, 14 May 2015 16:32:16 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-in-LookUp-Function/m-p/863341#M657105 Gysbert_Wassenaar 2015-05-14T16:32:16Z