Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date Range bucket >30 days,>15 days

Hi Guys:

i have created a straight table, in which i have listed the Tasks as follows

Taskid ProjectManager  CreateDate

1          JEJE                 01/01/2013

2          KEKE               12/13/2012

3         SMSM               12/28/2012

4          NNN                  11/13/2012

5          BBB                  12/10/2012

This table can grow very big. With this table,users also want a list box on filter criteria.Within this result set they can filter

only for Tasks where CeateDate <30 days. Also Tasks where Create Date is <15days

They want a list box somthing like    <30 days

                                                      < 15 days

how can achieve this.

I was checking other discussions on the similar topic on the forum. Looks like i should use interval match.

Interval match can be used to match dates into Month,Quarter etc.

Never used interval match before.

Is that the right approach for my problem and how do i do it.

Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Date Range bucket >30 days,>15 days

I would suggest creating an additional field in the script, something like this:

LOAD

     Taskkid,

     ProjectManage,

     CreateDate,

    if( today() - CreateDate < 15, '<15 days',

          if( today() - CreateDate < 30, '< 30 days' )) as DateInterval

FROM ...;

2 Replies
MVP
MVP

Re: Date Range bucket >30 days,>15 days

I would suggest creating an additional field in the script, something like this:

LOAD

     Taskkid,

     ProjectManage,

     CreateDate,

    if( today() - CreateDate < 15, '<15 days',

          if( today() - CreateDate < 30, '< 30 days' )) as DateInterval

FROM ...;

Not applicable

Re: Date Range bucket >30 days,>15 days

Thanks.

This worked.