topic How to count without null (null value in datetime) in QlikView

How to count without null (null value in datetime)

missain89 — Mon, 26 Jan 2026 18:19:17 GMT

Hi can someone help me to figure out this

= If(Len(Trim(allconvoyear))=0, Null(),count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}allmatric_no))

i dont want to count null value for allconvoyear because in my graph the convoyear null value is showing the null value 9k++

Re: How to count without null (null value in datetime)

Arthur_Fong — Wed, 18 Sep 2019 05:32:22 GMT

Try this:

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'},allmatric_no-={"=Len(Trim(allconvoyear))<1"}>}allmatric_no))

Re: How to count without null (null value in datetime)

missain89 — Wed, 18 Sep 2019 06:16:59 GMT

urm still not working 😞

Re: How to count without null (null value in datetime)

Arthur_Fong — Wed, 18 Sep 2019 07:02:53 GMT

Try this:

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'},allstatus-={"=Len(Trim(allconvoyear))<1"}>}allmatric_no))

If still not working, please provide sample app.

Re: How to count without null (null value in datetime)

missain89 — Wed, 18 Sep 2019 07:17:35 GMT

still not working,

here is my sample app

Re: How to count without null (null value in datetime)

StarinieriG — Wed, 18 Sep 2019 07:48:57 GMT

try with this expression

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}

If(Len(allconvoyear)>0,allmatric_no))

Re: How to count without null (null value in datetime)

Brett_Bleess — Mon, 30 Sep 2019 15:04:39 GMT

Did Giulia's last comment get things working? If so, please be sure to use the Accept as Solution button on their post to give them credit for the help and to let others know what worked. If you did something else, please consider posting that and then marking it, and if you are still working on things, leave an update for us.

Regards,
Brett