topic Re: Set Analysis Date Range in QlikView

Set Analysis Date Range

chaitanyajami — Thu, 20 Oct 2016 06:48:41 GMT

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])

Re: Set Analysis Date Range

sunny_talwar — Thu, 20 Oct 2016 17:09:21 GMT

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])

Re: Set Analysis Date Range

chaitanyajami — Fri, 21 Oct 2016 06:22:10 GMT

Hi Sunny ,

Thanks for suggestion , i will implement and check.