Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Determine Publish rate of accounts using SalesOrderStatus

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

6 Replies

Re: Determine Publish rate of accounts using SalesOrderStatus

Something like this:

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

Not applicable

Re: Determine Publish rate of accounts using SalesOrderStatus

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

Re: Determine Publish rate of accounts using SalesOrderStatus

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

MVP
MVP

Re: Determine Publish rate of accounts using SalesOrderStatus

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

Not applicable

Re: Determine Publish rate of accounts using SalesOrderStatus

Thanks for the tip Massimo!

Not applicable

Re: Determine Publish rate of accounts using SalesOrderStatus

Thank you Nicole. That did the trick!

Community Browser