topic Re: Expression to Select Certain Date Range in QlikView

Expression to Select Certain Date Range

Wed, 08 Jul 2015 13:18:45 GMT

Hi,

I have a large amount of data, of which I draw a variety of charts from. The data has a date range of several years; and for some of the charts I would like to just report on certain years/months. Is there an expression I can add to my charts that would filter on year/month? If Start Date = xx/xx/15 effectively.

Part of my data table looks something like this:

Name	Start Date	End Date
JOB123	5/06/2013	5/06/2013
JOB123	11/06/2015	11/06/2015

Kind regards,

Tristan

Re: Expression to Select Certain Date Range

sunny_talwar — Wed, 08 Jul 2015 13:23:56 GMT

If I understand you well, you might be able to use a set analysis like this:

{<[Start Date] = {"$(='>=' & Date(YearStart(Today()), 'M/DD/YYYY'))"}>}

Re: Expression to Select Certain Date Range

sunny_talwar — Wed, 08 Jul 2015 13:26:06 GMT

See if this helps:

Best,

Sunny

Re: Expression to Select Certain Date Range

Wed, 08 Jul 2015 13:49:13 GMT

Thanks very much Sunny; that's done it!

Best,
Tristan

Re: Expression to Select Certain Date Range

sunny_talwar — Wed, 08 Jul 2015 13:51:34 GMT

No problem Tristan‌

I am glad I was able to help.

Best,

Sunny