topic -= & = vs e()*p() in QlikView

-= & = vs e()*p()

cbaqir — Wed, 13 Dec 2017 17:00:37 GMT

My current pie chart shows % of DEFECT_ID in the CUR_GOV_PROCESS_QUEUE of 'Regional Clinical Informatics' by CUR_STATUS.

=Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}>}distinct DEFECT_ID)/Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}>} TOTAL distinct DEFECT_ID)

I need to modify this to exclude those that PREVIOUSLY were in any GOV_PROCESS_QUEUE = ERC*.

I've tried -= & = vs e()*p() but I can't get either to work correctly. Any help would be appreciated.

Re: -= & = vs e()*p()

sunny_talwar — Wed, 13 Dec 2017 17:02:47 GMT

May be this

=Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>}distinct DEFECT_ID)/Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>} TOTAL distinct DEFECT_ID)

Re: -= & = vs e()*p()

cbaqir — Wed, 13 Dec 2017 19:27:38 GMT

I think this works. Thanks Sunny!