Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the syntax to select null values in set analysis ?
{"=null()"} is not good...
Thanks
Try this
YourField-={*}
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
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...
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)
Hellow,
sorry but it don't works...
Does the field ADHERENT_DTSORTIE is null ?
Hello Canevet,
Can you attach a sample file. or exact expression which you are using for ADHERENT_DTSORTIE.?
Thanks,
Angad
Here is an extraction xls of my table
By sample file i meant, the sample of QVW file. so that I can check the expressions.
Thanks,
Angad
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);