topic nul values in QlikView

nul values

master_student — Wed, 21 Sep 2016 14:13:54 GMT

Hello nice people

I would like to add a condition in my expression; the condition is to count cases only if the status dimension <> from nul

here is the expression :

=count(if(LONG_DESC_STATUS <> 'Demande ' AND LONG_DESC_STATUS <> 'Info ' AND LONG_DESC_STATUS <> 'Abandonné' AND LONG_DESC_STATUS <> ' ',if((date([Date création],'DD/MM/YYYY'))>=(date(Max_date-7,'DD/MM/YYYY')),CASE_ID)))

it didn't work, it always count the null values of the LONG_DESC_STATUS dimension.

Any idea please

Thanks a lot

Re: nul values

Anonymous — Wed, 21 Sep 2016 14:18:21 GMT

did you test with isnull?

AND not isnull(LONG_DESC_STATUS),if

similiar would be do use len

AND len(LONG_DESC_STATUS)> 0,if

Re: nul values

master_student — Wed, 21 Sep 2016 14:20:58 GMT

Thanks a lot

Re: nul values

Anil_Babu_Samineni — Wed, 21 Sep 2016 14:29:53 GMT

Perhaps This

If(notIsNull(LONG_DESC_STATUS),Count(LONG_DESC_STATUS -={'Demande ','Info','Abandonné'} CASE_ID))

First try The above then try the below one

If(notIsNull(LONG_DESC_STATUS),Count({<LONG_DESC_STATUS -={'Demande','Info','Abandonné'}, [Date création] = {'>= (Date(Max_date)-7) '}>} CASE_ID))