topic Only certain dates. in QlikView

Only certain dates.

bobbydave — Fri, 20 Nov 2020 18:02:30 GMT

I have a calendar that goes back as far as 2010.

I only want to show from 2014 onwards.

if(date(date#(Calls.Date, 'DD/MM'YYYY'), 'YYYY') >= '2014', Calls.Date)

So I am converting Calls.Date to a year and if it is greater than 2014, keep this.

I know there has to be an easier way.

Is there?

Re: Only certain dates.

sunny_talwar — Wed, 16 Sep 2015 12:55:44 GMT

May be this:

If(Year(Date#(Calls.Date, 'DD/MM/YYYY')) >= 2014, Calls.Date)

Re: Only certain dates.

bobbydave — Wed, 16 Sep 2015 13:01:15 GMT

Excellent.

Thanks.

Re: Only certain dates.

jonathandienst — Wed, 16 Sep 2015 13:06:13 GMT

The date interpretation logic should be in your load script; as well as derived date fields. It will make expressions and sorting simpler to implement. So instead of

LOAD

...

Calls.Date,

Do this:

LOAD

...

date(date#(Calls.Date, 'DD/MM/YYYY')) As Calls.Date,

Year(date(date#(Calls.Date, 'DD/MM/YYYY'))) As Calls.Year,

Now your front end expression is

=If(Calls.Year >= 2014, Calls.Date)