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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

2 Replies
swuehl
MVP
MVP

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