topic Re: Convert Expression to Script in QlikView

Convert Expression to Script

djbloiss — Thu, 12 Jul 2018 12:54:32 GMT

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?

Re: Convert Expression to Script

Anil_Babu_Samineni — Thu, 12 Jul 2018 12:56:09 GMT

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

Re: Convert Expression to Script

djbloiss — Thu, 12 Jul 2018 13:02:32 GMT

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.