App Development

[Evan0211]

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:

=Count({<

[SAMID]={'> $(=date(today()))'}

>} [SAMID])

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.

Any help would be appreciated.  Thanks!

[GaryGiles · Accepted solution]

When using > in your set analysis criteria, you need to use double quotes " instead of single quotes '.

=Count({<[SAMID]={">$(=date(today()))"}>} [SAMID])

[Evan0211]

Thanks but it is still returning 0. Do I need to do any type of conversion on the [SAMID] to be able to compare it against today()?

[GaryGiles]

Is SAMID a date field?  I assumed that was the due date field.  You need to use the due date field as the field in the set analysis.