topic Count values between two dates in QlikView

Count values between two dates

Thu, 30 Aug 2012 14:42:09 GMT

Hey there,

hope you can help me. I thought it should be quite easy but either it is not or I am still too much of a beginner

Ich have a set of data regarding the acceptance tests of our machines containing amongst others a column with the date of acceptance test and a column with the number of the acceptance certificate.

Would I would like to display is the number of acceptance test conducted in the last 4 weeks. Therefore I created a variable "MonthBack" (today - 31 days) and this is what I tried without success:

=if([AC Results.Date]>=(MonthBack), Count([AC no.]))

The variable is ok and giving the correct date, but the code does not work.

Can anybody help?

Thanks a lot,

Max

Re: Count values between two dates

whiteline — Thu, 30 Aug 2012 15:06:25 GMT

=if([AC Results.Date]>='$(MonthBack)', Count([AC no.]))

Re: Count values between two dates

MayilVahanan — Thu, 30 Aug 2012 16:47:50 GMT

Did you check both format is same . MonthBack and [AC Results.Date] ? If so,

or use date(MonthBack,'DD/MM/YYYY') like this ..

Count({<[AC Results.Date] = {'>=$(=MonthBack)'} >}[AC no.])

Hope it helps

Re: Count values between two dates

Thu, 30 Aug 2012 16:51:30 GMT

Perfect, that's it - date format is both the same, but my code was wrong.

Big thanks!!