Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

jagjivvt
Contributor

Set analysis using start and end dates

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    

1 Solution

Accepted Solutions

Re: Set analysis using start and end dates

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.


talk is cheap, supply exceeds demand
2 Replies
Not applicable

Re: Set analysis using start and end dates

Hi

Do you can post your QVW file.

I do a example and worked perfectly

Re: Set analysis using start and end dates

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.


talk is cheap, supply exceeds demand
Community Browser