Select null values in set analysis

[#1]

What is the syntax to select null values in set analysis ?

{"=null()"} is not good...

Thanks

[Anonymous]

Try this

YourField-={*}

[Gysbert_Wassenaar]

Something like {<FieldX -= {'*'} >} usually works. But a better way is to replace nulls with real values in the script. See this document for more information: NULL handling in QlikView

[#4]

Thank You but

=count({$<LIAISON_POLICE_DTAFFIL={"<=$(=Effectifs_au)"},LIAISON_POLICE_DTRADIAT={">=$(=Effectifs_au)"}+{"01/01/0001"},ADHERENT_DTSORTIE={">=$(=Effectifs_au)"}+{<ADHERENT_DTSORTIE -= {'*'} >}>}ADHERENT_NOUNIQUE)

it returns nothing...

[Gysbert_Wassenaar]

Yes, well you have some extra >} thingies. I'm not sure what you're trying to do, but the syntax isn't correct. Maybe this works:

=count({$<LIAISON_POLICE_DTAFFIL={"<=$(=Effectifs_au)"},LIAISON_POLICE_DTRADIAT={">=$(=Effectifs_au)"}+{"01/01/0001"},ADHERENT_DTSORTIE={">=$(=Effectifs_au)"}>}+{<ADHERENT_DTSORTIE -= {'*'} >}ADHERENT_NOUNIQUE)

[#6]

Hellow,

sorry but it don't works...

Does the field ADHERENT_DTSORTIE is null ?

[#7]

Hello Canevet,

Can you attach a sample file. or exact expression which you are using for ADHERENT_DTSORTIE.?

Thanks,

Angad

[#8]

Here is an extraction xls of my table

[#9]

By sample file i meant, the sample of QVW file. so that I can check the expressions.

Thanks,

Angad

[#10]

ADHERENT:

LOAD ADHERENT_NOASSUR,

  ADHERENT_NOBENEF,

  PREVOYANCE_LIEN_NOASSUR,

  ADHERENT_NOUNIQUE,

  ADHERENT_NOSS,

  ADHERENT_CDBENEF,

     ADHERENT_LIBELLE_BENEF,

     ADHERENT_CDCIVI,

     ADHERENT_CODEVIP,

     ADHERENT_DTNAIS,

       ADHERENT_DTENTREE,

       ADHERENT_DTSORTIE,

        ADHERENT_MOTIF_SORTIE,

      ADHERENT_LIB_RGLT,

     ADHERENT_CDATTACH,

     ADHERENT_NOATTACH,

     ADHERENT_NMTIERS,

  ADHERENT_NM2TIERS,

  ADHERENT_CDPOST,

  ADHERENT_NMVILLE

FROM

$(Chemin_qvd)ADHERENT.qvd

(qvd);