Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set Analysis in LookUp Function

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.

 

date#(WeekEnd(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'), 0,2),'MM/DD/YYYY') as 'ActionDate'

Thank you for the help!

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set Analysis in LookUp Function

You can't use set analysis in the load script. You'll have to use an if-statement.


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: Set Analysis in LookUp Function

You can't use set analysis in the load script. You'll have to use an if-statement.


talk is cheap, supply exceeds demand