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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KimSharp
Contributor
Contributor

Error in syntax but there is no message to say where the error is.

Pick( _%TransactionType
, $(expFilteredPlannedReceiptQty)
, $(expFilteredMaterialRequirementQty)
, Null()
)

This is the code.  I attached a screenshot of the error.  The variables don't seem to have any errors.

expFilteredPlannedReceiptQty = Sum({<[_GeneratedRow]={0},%MRPTransactionType={1},%MRPOrderType={"*"}-{"$(vIncludeMRPOrders)"},[MRP Transaction Date]={"<$(vMaxTransactionDate)"}>} [MRP Movement Qty])

expFilteredMaterialRequirementQty = Sum({<[_GeneratedRow]={0},%MRPTransactionType={2},[MRP Transaction Date]={"<$(vMaxTransactionDate)"}>} [MRP Movement Qty])

 

Can anyone tell me what's wrong with the syntax here?

Labels (2)
0 Replies