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.
The current expression i am having an issue with is attached to this post (as it is marked as spam for whatever reason when i include it via text).
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.
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.
