topic Re: set analysis dates comparison in QlikView

set analysis dates comparison

Mon, 26 Jan 2026 18:19:17 GMT

Hi every body ,

i'm trying to obtain clients commands between two dates and this is my expression

=count( {$ < [Date CA]={'>=$(=startdate)'}, [Date CA]={'<=$(=enddate)'} > } distinct [Nom Client])

startdate and enddate are variables

giakoum — Thu, 06 Feb 2014 09:31:19 GMT

Looks generally correct. Try eliminating the = sign and combine them into one :

Count({$<[Date CA]={'>=$(startdate)<=$(enddate)'} > } distinct [Nom Client])

ThornOfCrowns — Thu, 06 Feb 2014 09:37:59 GMT

An example:

{$<Year={">=2006 <=2010"}>}

will return the results for years 2006 to 2010 inclusive

Thu, 06 Feb 2014 09:42:24 GMT

try this

=count( {$ < [Date CA]={ '>=$(=startdate) <= $(=enddate)' } > } distinct [Nom Client])

Thu, 06 Feb 2014 10:43:05 GMT

thanks for all