topic Re: Percentage expression in QlikView

Percentage expression

Mon, 14 Dec 2015 15:10:17 GMT

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

swuehl — Mon, 14 Dec 2015 15:12:35 GMT

Maybe just divide both expressions:

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

Mon, 14 Dec 2015 15:17:15 GMT

Just missing extra brackets - thanks

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