topic Re: Set Analysis Count question in QlikView

Set Analysis Count question

Thu, 01 Nov 2012 15:57:31 GMT

Hi, I have an expression like this.

='Total Number of Delivered Assets without CC: ' & Count( {$<[CCConfirmed]={'N','U'},[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

Currently only the assets with CCConfirmed with 'N' or 'U' and CCValid status of 'N' or 'U' are being counted

Instead I only want to count them if it is either of the condition.

CCConfirmed = 'N' or 'U'

CCValid = 'N' or 'U'

Any help will be appreciated. Thanks

Re: Set Analysis Count question

Thu, 01 Nov 2012 16:05:48 GMT

='Total Number of Delivered Assets without CC: ' & Count( {$<[CCConfirmed]={'N','U'}>+<[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

Re: Set Analysis Count question

Thu, 01 Nov 2012 16:14:00 GMT

Hi, thanks for your response. This one is now showing the count for only the first two fields and not considering displaystatus at all.

Re: Set Analysis Count question

Thu, 01 Nov 2012 16:21:03 GMT

Okay, then try this:

='Total Number of Delivered Assets without CC: ' &

Count( {$<[CCConfirmed]={'N','U'},[DisplayStatus]={'Completed','Delivered'}

>+<

[CCValid]={'N','U'},[DisplayStatus]={'Completed','Delivered'}>} AssetId )

Re: Set Analysis Count question

Thu, 01 Nov 2012 16:41:36 GMT

Thanks. That worked.