Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dabandel
Contributor
Contributor

Set analysis problem with Date field

Hello,

I'm new to Qlik Sense and following many of the excellent tutorials and videos, I'm still getting a lot of syntax errors. I'm trying to enter a KPI where I am counting the number of dates in a field (FA_Date), but only where the (FA_Date) is >= 06/01/2018. I've used syntax similar to the following but keep getting "error in expression" :

Count(FA_Date)

Count({...}FA_Date)

Count({1<...>}FA_Date)   // ...and.. here's where everything goes haywire...

Count({1<FA_Date>={"06/01/2018"}>}FA_Date)

Any help is GREATLY appreciated!

Labels (1)
2 Replies
dabandel
Contributor
Contributor
Author

To clarify a bit, I did get the "OK" on the following syntax, but the result set was "0" (answer should have been about 170 rows):

Count({<FA_Date={">=(6/01/2018)"}>}FA_Date)

Thanks!

Vegar
MVP
MVP

Try
Count({<FA_Date={">=6/01/2018"}>}FA_Date)