Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!