KPI to display a count of dates greater than today
I am new to Qlik and have a question on a dashboard I am building. Currently I have a table of data with a column that has due dates. I am trying to use a KPI control to show the count of dates that are greater than today. Eventually this will morph into dates that are within 1 week and another within 1 month.
The column in the table is called SAMID
The code I am using in the fx of the KPI is:
but it always returns 0. In my table, there are 2 dates that are greater than today, so the result set I am looking for is 2.