topic Re: Set analysis using start and end dates in QlikView

Set analysis using start and end dates

jagjivvt — Thu, 28 Feb 2013 14:09:14 GMT

Hi,

i am using this in an expression to count the number of records received from 01/01/2013 to 31/01/2013 inclusive. the result should be 97 but it only returns 93 and ignores all records that are for 31/01/2013.

count({$<[CMS Entered Date]= {'>=01/01/2013<=31/01/2013'} >} [CMS Entered Date])

please advise where i am going wrong.

thanks

vijay

Re: Set analysis using start and end dates

Thu, 28 Feb 2013 14:25:49 GMT

Do you can post your QVW file.

I do a example and worked perfectly

Re: Set analysis using start and end dates

Gysbert_Wassenaar — Thu, 28 Feb 2013 15:14:39 GMT

The problem is that your dates are actually timestamps. So the dates for 31/01/2013 are larger than 31/01/2013 00:00:00. You either need to use < 01/02/2013 or remove the time part of your dates, for example with floor([CMS Entered Date]) in the script.