Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Lawrence
Contributor III
Contributor III

Utilizing the Now() Function in Set Analysis

Hey All,

Im looking to see if someone can point me in the right direction as to how I properly set up a set analysis formula that leverages the Now() function and compares it to a date parameter with less than/greater than. I have attached what i currently have to this post (as for whatever reason, it gets locked out if i post the formula in the box), but i am basically attempting to get a count of interviews that have not been conducted at the time of viewing the table (Greater Than).

Any insight would be appreciated!

2 Replies
Vegar
MVP
MVP

Try something like this.

count({<I.CompletedOn={"<$(=now())"}>}I.Invited)

Christopher_Lawrence
Contributor III
Contributor III
Author

I think this would work for Interviews that were completed during the current time, opposed to before or after (looking for how to do it with greater than/less than opposed to equal).