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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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
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