Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)