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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Lawrence
Contributor III
Contributor III

Utilizing Greater Than Now() inside Set Analysis

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. 

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

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?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.