Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Creating a calculated field to a table. I want to only sum only those sales transaction which have been characterized in any of 7 different ways that transaction should be added to the total.
If([Merchant-defined Order Status] = 'Completed' ,[Merchant-defined Order Status]),[product unit price}). This works but when I try to add other Merchant defined statuses, such as shipped' using "or" it gives me an error of "unexpected token".
Ok, my bad, the first thing I should've understood is where you were.
The expression writer on the Data Manager wizard is a bit controlled and more limited compared to expressions you could write on the Load Script, for example I noticed that expressions like this work If(FieldName='X',Y,Z) but this is a problem: If(FieldName='X' OR FieldName = 'W',Y,Z)
Any way, everything the Data Manager does will be "translated" on the the load script and few more things, so you'll be able to see what the wizard did but at the end everything is on the Load Script
Any way, I just confirmed that you can write this on the expression editor when creating a calculated field in the Data Manager,
I hope this finally helps you,
IF(Match([Merchant-defined Order Status],'Completed','Shipped','Awaiting Payment','Awaiting Shipment','Partially Shipped','Partially refunded'),[Product Unit Price])
Spoke to someone at Qlik who suggested that i create a flag with the type of order such as "1" and us match and if which worked.