Set Analysis with Greater Than Now()

Christopher_Lawrence — Thu, 24 Mar 2022 18:13:18 GMT

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.

topic Set Analysis with Greater Than Now() in App Development

Set Analysis with Greater Than Now()