6 Replies Latest reply: Feb 18, 2014 4:03 PM by Steve Dillon RSS

    Determine Publish rate of accounts using SalesOrderStatus

    Steve Dillon

      I have loaded transactions into QlikView. These transactions have a status value associated with them (SalesOrderStatus)

       

      I need to find the % of orders with a SalesOrderStatus = 'Published' and divide that into the number of orders with a SalesOrderStatus = 'Ordered'.

       

      This would give me my publish rate, I just don't know how to write this in an expression. Can someone demonstrate how I might be able to do this?