calculate amount with null values

[bartwelvaarts]

hello friends of the qlik community,

I would like to calculate the amount where the date is higher then 'X' or where a date does not exists. But it does not calculate the records with null values. I tried this, but it did not work. Does someone have any suggestions?

final:
load
amount
from 'source'
where date_1 <= 30-04-21

and date_2 > 30-04-21

or isnull(date_2)

[JuanGerardo]

Maybe date format can help:

final:
load
amount
from 'source'
where date_1 <=Date#('30-04-21', 'DD-MM-YY')

and date_2 > Date#('30-04-21', 'DD-MM-YY')

or isnull(date_2)

JG