11 Replies Latest reply: Feb 3, 2018 9:30 AM by Howard Levin RSS

    Still new to Qlik Sense. Having trouble with "if and Or"

    Howard Levin

      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".