topic Re: Count if with exceptions in QlikView

Count if with exceptions

dmxmikey — Wed, 25 Nov 2020 16:16:04 GMT

I have the below expression

Count(DISTINCT{<ORDER_DETAILS.Cred_stat2_Description -= {0}>}[ORDER_DETAILS.O-HInvoice])

but would like to exclude

"ORDER_DETAILS.Cred_stat2_Description" where is

debit note

damage?

Re: Count if with exceptions

Chanty4u — Tue, 24 Jul 2018 17:20:25 GMT

try this

Count(DISTINCT{<ORDER_DETAILS.Cred_stat2_Description -= {""},ORDER_DETAILS.Cred_stat2_Description-={'DebitNote'}>}[ORDER_DETAILS.O-HInvoice])

Re: Count if with exceptions

dmxmikey — Tue, 24 Jul 2018 17:32:11 GMT

works well with one exception and tried below is that correct as i need to exclude more than one description?

Count(DISTINCT{<ORDER_DETAILS.Cred_stat2_Description -= {""},ORDER_DETAILS.Cred_stat2_Description-={'DebitNote,Damage'}>}[ORDER_DETAILS.O-HInvoice])

Re: Count if with exceptions

sunny_talwar — Tue, 24 Jul 2018 17:33:43 GMT

Try this

Count(DISTINCT {<ORDER_DETAILS.Cred_stat2_Description -= {'0', 'DebitNote', 'Damage'}>} [ORDER_DETAILS.O-HInvoice])

Re: Count if with exceptions

Chanty4u — Tue, 24 Jul 2018 17:35:16 GMT

you can add any num of field values by adding comma

Count(DISTINCT{<ORDER_DETAILS.Cred_stat2_Description -= {""},ORDER_DETAILS.Cred_stat2_Description-={'DebitNote,Damage','Here','Here','Here'}>}[ORDER_DETAILS.O-HInvoice])

like "here" you can add your descriptions