topic Re: not null Qlikview in QlikView

not null Qlikview

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

Hi all,

I want to do an expression in which I don't want that null value be loaded. so I created this one in wich i want to get only values from N_MAT_VICT where is it not null. The type of this column is varchar:

= if(match(GetFieldSelections(Month),'juin'), num(count( {$<[F_VICT_1]={'O'}, I_FAIT_YP={78} ,(N_MAT_VICT) <> Null() , [Month]={'juin'}

>} Data_Fact))

but it does not work.
Someone can help me pls.
Thank you

Re: not null Qlikview

avinashelite — Mon, 07 Mar 2016 12:25:56 GMT

try like this

= if(match(GetFieldSelections(Month),'juin'), num(count( {$<[F_VICT_1]={'O'}, I_FAIT_YP={78} ,N_MAT_VICT = (*) , [Month]={'juin'}

>} Data_Fact))

= if(match(GetFieldSelections(Month),'juin'), num(count( {$<[F_VICT_1]={'O'}, I_FAIT_YP={78} ,N_MAT_VICT = {'*'} , [Month]={'juin'}

>} Data_Fact))

= if(match(GetFieldSelections(Month),'juin'), num(count( {$<[F_VICT_1]={'O'}, I_FAIT_YP={78} ,N_MAT_VICT = ("=if(len(trim(N_MAT_VICT ))>0, N_MAT_VICT ) ") , [Month]={'juin'}

>} Data_Fact))

Re: not null Qlikview

yahiaoui — Mon, 07 Mar 2016 13:40:07 GMT

it does not work ; threr is my expression

=if(match(GetFieldSelections(Month),'juin') , num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'},[Month]={'juin','mai'} , [N_MAT_VICT] = (*)

>} Data_Fact))

,if(match(GetFieldSelections(Month),'mai'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'mai','avr.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'avr.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'mars','avr.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'mars'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'mars','févr.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'févr.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'janv.','févr.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'juil.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'juil.','juin'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'août'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'juil.','août'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'sept.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'sept.','août'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'oct.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'sept.','oct.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'nov.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'nov.','oct.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'déc.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'nov.','déc.'}

>} Data_Fact))

,if(match(GetFieldSelections(Month),'janv.'), num(count( {$<[F_VICT_1]={'O'}, [Regr_AtteintesVoyageurs]-={'Vols à la tire'}, [Month]={'janv.','déc.'}

>} Data_Fact))

))))))))))))

Re: not null Qlikview

sunny_talwar — Mon, 07 Mar 2016 14:00:29 GMT

You can try these as well"

=If(Match(GetFieldSelections(Month),'juin'),

Num(Count({$<[F_VICT_1] = {'O'}, I_FAIT_YP = {78}, N_MAT_VICT = ("=Len(Trim(N_MAT_VICT)) > 0"), [Month] = {'juin'}>} Data_Fact))

Re: not null Qlikview

jonathandienst — Mon, 07 Mar 2016 14:16:10 GMT

This should exclude all null values:

= if(match(GetFieldSelections(Month),'juin'), count({$<[F_VICT_1]={'O'}, I_FAIT_YP={78}, N_MAT_VICT ={'*'}, [Month]={'juin'} >} Data_Fact))

(The bold text selects everything except nulls)

Re: not null Qlikview

avinashelite — Tue, 08 Mar 2016 05:18:44 GMT

Sorry . I did a typo error try like this

= if(match(GetFieldSelections(Month),'juin'), num(count( {$<[F_VICT_1]={'O'}, I_FAIT_YP={78} ,N_MAT_VICT = {'*'} , [Month]={'juin'}

>} Data_Fact))

Its flower bracket

Re: not null Qlikview

engishfaque — Tue, 08 Mar 2016 07:14:04 GMT

Dear Walid,

Kindly use listed below expression,

Expression 1:

=If(match(GetFieldSelections(Month),'juin'), num(count({$<[F_VICT_1]={'O'}, I_FAIT_YP={78}, N_MAT_VICT = {'Null()'}, [Month]={'juin'}>} Data_Fact)))

Expression 2:

=If(match(GetFieldSelections(Month),'juin'), num(count({$<[F_VICT_1]={'O'}, I_FAIT_YP={78}, N_MAT_VICT = {"=Len(Trim(N_MAT_VICT)) > 0"}, [Month]={'juin'}>} Data_Fact)))

Kind regards,

Ishfaque Ahmed