Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Contributor III
Contributor III

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:

=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!

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

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

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

View solution in original post

3 Replies
GaryGiles
Specialist
Specialist

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

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

View solution in original post

Evan0211
Contributor III
Contributor III
Author

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
Specialist
Specialist

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.