Set Analysis Date Range

[chaitanyajami]

Hi all,

I really hope that you could assist me with the following.

Date filter is not working in Set analysis, I want to count the events that were planned from today , i have an event start date which is in mm/dd/yyyy format and i am using below expression in set analysis ,but I'm getting result by ignoring the date filter that is used, All hints are greatly appreciated.

Qlikview Date format in Global variable

SET DateFormat='M/D/YYYY';

Event date format:

date#(date(evnt_strt_dt),'mm/dd/yyyy')

as          [Evnt Start Date]

Set  Expression:

Count({<[Event Start Date]={">=$(date#(date(Today()),'mm/dd/yyyy'))"},[Event Status]={'PENDING','CONFIRMED'},[Quarter'Year]=,[Month'Yr]=>}Distinct [Event ID])

[sunny_talwar]

Try these changes:

Date(Date#(evnt_strt_dt,'MM/DD/YYYY')) as          [Evnt Start Date]

and then this expression:

Count({<[Event Start Date] = {">=$(=Date(Today()))"}, [Event Status] = {'PENDING','CONFIRMED'}, [Quarter'Year] =,[Month'Yr] =>} DISTINCT [Event ID])

[chaitanyajami]

Hi Sunny ,

Thanks for suggestion , i will implement and check.