topic Re: Count if before a date in QlikView

Count if before a date

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Count if before a date

trdandamudi — Fri, 12 May 2017 15:51:14 GMT

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

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

Re: Count if before a date

Fri, 12 May 2017 16:29:05 GMT

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?

Re: Count if before a date

trdandamudi — Fri, 12 May 2017 17:25:57 GMT

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