topic Date filter in QlikView

Date filter

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data with date formatted dd/mm/yyyy

I would like to create a filter pane for date before a certain date month and year, like records before 12/11/1993

IF ( DATE < 12/11/1993,1,0)

Is that how it works?

MK_QSL — Mon, 16 Jan 2017 08:54:35 GMT

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),1,0)

=If(Date < Date#('12/11/1993','DD/MM/YYYY'),Date)

susovan — Mon, 16 Jan 2017 09:07:10 GMT

Hi,

You can also try this below expression.

Expression:

if(StartDate<'2016-02-27',1,0)