Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Count if before a date

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
1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

Re: Count if before a date

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

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

View solution in original post

3 Replies
trdandamudi
Honored Contributor II

Re: Count if before a date

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

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

View solution in original post

Not applicable

Re: Count if before a date

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
Honored Contributor II

Re: Count if before a date

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