Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage expression

Expression for count of Concern Id:

Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID)

Expression for count of transactions:

Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo)

I need to set an expression to work out the percentage of concerns against transactions.

Can someone kindly put this together for me as the set analysis brackets are throwing me!

Thanks

Labels (1)
2 Replies
swuehl
Champion III
Champion III

Maybe just divide both expressions:

Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID) /  Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo)

Not applicable
Author

Just missing extra brackets - thanks

=(Count({<SaleMarker = {1}, DDiff_C = {0}>}ConcernID) /  Count({<SaleMarker = {1}, DDiff_T = {0}>}TransactionNo))*100