topic Re: Date Filter Help in QlikView

Date Filter Help

amit_saini — Wed, 22 Apr 2015 10:51:48 GMT

Hi Folks,

Please see the attachment and help me for 30, 60 and 90 days filter from today's date .

Result should be exactly same as calender.

Thanks,
AS

Re: Date Filter Help

awhitfield — Wed, 22 Apr 2015 11:09:16 GMT

Hi Amit,

you can do it simply if your refer to the following article:

https://community.qlik.com/blogs/qlikviewdesignblog/2014/06/06/dynamically-selecting-timeframes

Hope this point you in the right direction

Andy

Re: Date Filter Help

Gysbert_Wassenaar — Wed, 22 Apr 2015 11:21:34 GMT

Add flag fields to your calendar(s)

LOAD

...other fields...,

If( today()-Datefield<=30,1,0) as InLast30Days,

If( today()-Datefield<=60,1,0) as InLast60Days,

If( today()-Datefield<=90,1,0) as InLast90Days,

...some other fields...

FROM ...

Re: Date Filter Help

amit_saini — Wed, 22 Apr 2015 11:21:41 GMT

Hi Andrew,

See I know how to filter based on days , but problem is after these filters Calender selection result and result based on filters is not same.

Script Side:

Let vToday = num(Today());

$(vToday)-floor(num(Datefield)) AS DaysDifference,

30 days filter in list box:

=if(DaysDifference >= 0 and DaysDifference <=30, '30')

similarly I have done for 60 and 90 days filter.

Thanks,
AS

Re: Date Filter Help

amit_saini — Wed, 22 Apr 2015 11:34:07 GMT

Gysbert,

Thanks for your reply , all these I tried but issue is numbers are not matching. See below issue:

Example.

2015 filter: Week 4 2015 shows around 300 open tickets in the workload.(This result when you are doing selection from calendar objects)

90 filter: Week 4 2015 shows around 25 open tickets in the workload. Suspect the 30/60/90 filter is only showing tickets raised in the last 30/60/90 rather than the status over the last 30/60/90 (Result when you are doing selection for last 90 days filter)

Just to take example of week4-2015 , based on calender workload is around 300 and based on 90 filter it is around 25 . This data should match even if I'm doing selections from filters.

Thanks,

Re: Date Filter Help

amit_saini — Wed, 22 Apr 2015 11:39:21 GMT

Check this Bucket in application.

Thanks,
AS

Re: Date Filter Help

amit_saini — Thu, 23 Apr 2015 04:14:50 GMT

Hi . jagan‌ , gwassenaar‌

any suggestions here???

Thanks,