Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
View solution in original post
Something like this:
How would I format this as a % if I were to plug this expression into a text object
you can find the format in the "Number" tab of tablebox and charts
Thanks for the tip Massimo!
Thank you Nicole. That did the trick!