Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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
Master II
Master II

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

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

Not applicable
Author

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
Master II
Master II

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