Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.