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 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.
