Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
num(count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID),'##.##%')
Something like this:
count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID)
How would I format this as a % if I were to plug this expression into a text object
num(count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID),'##.##%')
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!