Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
djbloiss
Contributor III
Contributor III

Convert Expression to Script

I am taking this logic from an expression I am using, pulled out the parts that are unnecessary for a script and now need to convert it to a script.  How do I do that?

if(

    (Sum({$<SO_Closed={1}, DateKey={"<=$(vMax_SO_Closed_GlobalDateNum)>$(=vMax_SO_Closed_GlobalDateNum-DaysTillDead)"}}  [Actual Quantity])=0)

    AND

    sum([Case qty on hand])<>0

    ,

    True

)

vMax_SO_Closed_GlobalDateNum is today's date.  How would I get this logic in a script?

2 Replies
Anil_Babu_Samineni

This can be done, But why you want to use this in script instead UI?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
djbloiss
Contributor III
Contributor III
Author

Because I then want to use this flag in another report to show all customers who purchased these items AND only show those items.  I can easily put the flag in the set analysis to achieve this end.