topic Re: Count with AND OR Function in QlikView

Count with AND OR Function

Wed, 15 Feb 2017 14:46:49 GMT

Dear All,

I want to have all which is in this year plus i dont want blanks as well. but the function is not giving me the result.

count(distinct{$<KomDatenService={'*huawei*'},

St90={'>31/12/2016','<>blank'}

>}Link_Rev)

swuehl — Wed, 15 Feb 2017 15:14:50 GMT

I assume your St90 field shows date values. 'blank' mean NULL?

Then doing a numeric search should automatically exclude the records where St90 shows NULL.

You just need to create a numeric search string that correctly selects the date values:

count(distinct{$<KomDatenService={'*huawei*'}, St90={">31/12/2016"} >}Link_Rev)

or maybe

count(distinct{$<KomDatenService={'*huawei*'}, St90={"= St90 >= makedate(2017)"} >}Link_Rev)

Wed, 15 Feb 2017 15:23:14 GMT

thanks for the support. I have already defined null via variable as "Blank".

aarkay29 — Wed, 15 Feb 2017 16:12:29 GMT

Try This

count(distinct{$<KomDatenService={'*huawei*'},

St90={'>31/12/2016','<>'''}

>}Link_Rev)

count(distinct{$<KomDatenService={'*huawei*'},

St90={'>31/12/2016','<>$(=vBlank)'}

>}Link_Rev)