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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
artempotsuray
Contributor III
Contributor III

Set Analysis

Hi I'm trying to count the number of gages that have a LAST_MODIFIED_DATE of the current system date. I'm pulling data from a sql server so the LAST_MODIFIED_DATE column changes periodically for ever gage. I have this written but it is not giving me a result into a KPI:

Count(distinct {<Date([LAST_MODIFIED_DATE],'MM/DD/YYYY') = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

I also tried:

Count(distinct {<Date(Floor([LAST_MODIFIED_DATE]),'MM/DD/YYYY') = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

and

Count(distinct {<[LAST_MODIFIED_DATE] = {$(=Date(Today(), 'MM/DD/YYYY'))}>}GAGE_SN)

but the LAST_MODIFIED_DATE data has a timestamp with the date which I don't need to look at.

1 Solution

Accepted Solutions
sunny_talwar

Try this

Count(DISTINCT {<[LAST_MODIFIED_DATE] = {"=Floor([LAST_MODIFIED_DATE]) = Today()"}>} GAGE_SN)

View solution in original post

2 Replies
sunny_talwar

Try this

Count(DISTINCT {<[LAST_MODIFIED_DATE] = {"=Floor([LAST_MODIFIED_DATE]) = Today()"}>} GAGE_SN)

artempotsuray
Contributor III
Contributor III
Author

It worked! Thank you