Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
If it is in a chart you can use the below expression:
=count({<Delivered={'<=04/01/2017'}>} Delivered)
If it is in a chart you can use the below expression:
=count({<Delivered={'<=04/01/2017'}>} Delivered)
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?
You are welcome.. To get a better understanding of Set Analysis please go over the below link and it will help you:
Can you please close this thread by selecting correct answer.
Thanks