Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
i've replied to your post here
apart from that how will your data model have any data greater than last data reload timestamp?