Count if before a date

[#1]

Hello all, I have no coding background. When using Qlik to do a count if formula, I can't seem to make it work.

So I have a set of dates, and then I have to count this column if the date if before 4/1/2017. This column is already recognized as "date" in Qlik. Please help me with the formula. It would be something looks like this: =count(Delivered <='04/01/2017',(Delivered))

Thank you!!

               Delivered

6-Apr-2017

5-Apr-2017

4-Mar-2017

3-Apr-2017

2-Apr-2017

1-Mar-2017

3-Apr-2017

[trdandamudi · Accepted solution]

If it is in a chart you can use the below expression:

=count({<Delivered={'<=04/01/2017'}>} Delivered)

[#3]

Thank you!! I tried and it didn't work at the beg. because I guess the default date should be DD/MM/YY??but after I switch the position, it worked! THANK YOU SO MUCH!

Can you tell me when do I need to use quote?

[trdandamudi]

You are welcome.. To get a better understanding of Set Analysis please go over the below link and it will help you:

Set Analysis Presentation.pdf

Can you please close this thread by selecting correct answer.

Thanks