Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Determine Publish rate of accounts using SalesOrderStatus

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?

1 Solution

Accepted Solutions
Nicole-Smith

num(count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID),'##.##%')

View solution in original post

6 Replies
Nicole-Smith

Something like this:

count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID)

Not applicable
Author

How would I format this as a % if I were to plug this expression into a text object

Nicole-Smith

num(count({<SalesOrderStatus={'Published'}>}OrderID)/count({<SalesOrderStatus={'Ordered'}>}OrderID),'##.##%')

maxgro
MVP
MVP

you can find the format in the "Number" tab of tablebox and charts

Not applicable
Author

Thanks for the tip Massimo!

Not applicable
Author

Thank you Nicole. That did the trick!