topic multi conditions in QlikView

multi conditions

master_student — Thu, 23 Feb 2017 10:55:15 GMT

Hello Best Community Ever,

I have an expression count( {< DATE_CALCUL={ "$(=date(today()-1))"} >} DN_NUM)

and i would like to add this condition : not isnull(KIT) and not isnull(CODE_BOUTIQUE)

have you any idea ?

Thanks

Re: multi conditions

sunny_talwar — Thu, 23 Feb 2017 10:58:08 GMT

May be this:

Count({<DATE_CALCUL={ "$(=date(today()-1))"}, KIT = {'*'}, CODE_BOUTIQUE = {'*'}>} DN_NUM)

Re: multi conditions

MK_QSL — Thu, 23 Feb 2017 10:59:29 GMT

Count(

DATE_CALCUL={ "$(=date(today()-1))"},

DN_NUM = {"=DN_NUM = Not IsNull(KIT) or LEN(TRIM(KIT))<>0"},

DN_NUM = {"=DN_NUM = Not IsNull(CODE_BOUTIQUE) or LEN(TRIM(CODE_BOUTIQUE))<>0"},

DN_NUM)

Re: multi conditions

MK_QSL — Thu, 23 Feb 2017 11:00:27 GMT

Count(

DATE_CALCUL={ "$(=date(today()-1))"},

IF(Len(Trim(KIT))<>0 and Len(Trim(CODE_BOUTIQUE)) <> 0,DN_NUM))

Re: multi conditions

MK_QSL — Thu, 23 Feb 2017 11:00:54 GMT

I thought tooooo much (may be) !!!

Re: multi conditions

veeranj — Thu, 23 Feb 2017 11:24:01 GMT

Hi,

Try this

Count({<DATE_CALCUL={ "$(=date(today()-1))"}, KIT_filter = {'*'}-{'null'}, CODE_BOUTIQUE_filter = {'*'}-{'null'}>} DN_NUM)

IN the backend/script ,create the filters as KIT_filter and CODE_BOUTIQUE_filter displaying 'null' and 'notnull' as description ..... and use the above logic . it will eliminate all the null values

thanks,

Anjee