Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

View solution in original post

6 Replies
Highlighted

Something like this:

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

Highlighted
Not applicable

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

Highlighted

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

View solution in original post

Highlighted
MVP
MVP

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

Highlighted
Not applicable

Thanks for the tip Massimo!

Highlighted
Not applicable

Thank you Nicole. That did the trick!