Utilizing Greater Than Now() inside Set Analysis

[Christopher_Lawrence]

Hey All,

I have a case where I am looking to find the count of Interviews that have not been completed at the second a user looks at the pivot table that displays the count (opposed to the Today() function). However, I seem to be having an issue getting set analysis to work. 

I currently have this as my expression:

=Count({<JC.StageNumber = {2}, I.CompletedOn = {">Now()"}>}I.Invited)

I am unsure if this might be due to Qlik being specific to date formats, as i believe Now() returns the style of mm/dd/yyyy hh:mm:ss AM/FM, where as the field for I.CompletedOn is set to the format yyyy-dd-mm hh:mm:ss.ms. 

Looking for any insight into this. 

Also, in regards to the Now() function, i assume this function correlates to the device local timezone? If that is the case, I am seeing that the function provides a time that is one hour ahead of my current time, which i am unsure of why that is, as my device is set to central time (US and Canada), where as the time presented seems to be EST. 

[vinieme12]

https://community.qlik.com/t5/New-to-Qlik-Sense/Now-Function-with-Greater-Than-Set-Analysis/td-p/190...

i've replied to your post here

apart from that  how will your data model have any data greater than last data reload timestamp?