Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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