Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

if logic with null values

Hi Experts,

Can any one please help me on below requirement.

Thanks in advance.

4 Replies
gerry_hdm
Contributor II

Re: if logic help

using

peek  or  previous

greetings gerry

gerry_hdm
Contributor II

Re: if logic with null values

if(FieldGroup = previous(FieldGroup)  and FieldCross <> previous(FieldCross),  peek('Crosswert') & '!'& FieldCross ,FieldCross) as Crosswert,

gruß gerry

zebhashmi
Valued Contributor

Re: if logic with null values

Not sure

if(Len(yourfield)<1,1,0)

sas_fundm
New Contributor II

Re: if logic with null values

i guess the IsNull-function performs better...

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).