Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor II

Set analysis with Null count help

Hi Experts,

Can any one please help me on below syntax.

I have two dates like [Start Date] and [End Date]

Here I need to count null from [Start Date] where [End Date] is less than Todays date.

I have tried this syntax but its not working. Please let me know am I missed any thing in the syntax.

=nullcount({<[End Date]<{today()}>}[Start Date])

 

Thanks in advance.

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis with Null count help

Are your dates valid numeric date type or are they strings? Assuming the former:

=NullCount({<[End Date] = {"<$(=Today())"}>} [Start Date])
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply
MVP
MVP

Re: Set analysis with Null count help

Are your dates valid numeric date type or are they strings? Assuming the former:

=NullCount({<[End Date] = {"<$(=Today())"}>} [Start Date])
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post