topic Re: How to display data between two dates in QlikView

How to display data between two dates

Anonymous — Mon, 25 May 2015 06:44:47 GMT

Hi,

I have two date fields like CN_EDT(contracts start date) and CN_XDT(contracts end date).I have an agent and year filters. If I select one agent and year it has to display number of contracts has done by an agent in that year between these two dates.

Please help me to solve this

Thanks in advance

Anusha K

Re: How to display data between two dates

timanshu — Mon, 25 May 2015 07:05:48 GMT

if(Year([contracts start date]) = Year and year( [contracts end date] )= Year, Count( Contracts))

Re: How to display data between two dates

avinashelite — Mon, 25 May 2015 07:10:08 GMT

create two variables to read the start and end date,

then try like this:

count({<Calender_Date={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}contract )

Re: How to display data between two dates

amit_saini — Mon, 25 May 2015 07:10:24 GMT

Hi Anusha,

See the attachment.

Thanks,

Re: How to display data between two dates

Mon, 25 May 2015 07:16:46 GMT

Try

count({<agent,year,date_field={'>$(=[contracts start date]) <= $([contracts end date])'}>}contracts)

Re: How to display data between two dates

prajapatiamar38 — Mon, 25 May 2015 07:22:17 GMT

Hi,

Try this one I hope it will work...Don't directly Copy paste this.Modify it according to your requirement.

=count({<Date={>=CN_EDT<=CN_XDT},Agent=$::Agent,Year=$::Year>}contracts)

Re: How to display data between two dates

Mon, 25 May 2015 07:22:52 GMT

Use Set Analysis as suggested by other community members, but keep in mind the Date Format of all comparison dates must be of same format.