Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get sysDate in qlikview and compare it with other date ?

Hi all ,

How can I get the system date in qlikview and also wanted to know that how can i compare it with some other date , so that some other operation can be performed.

like

Count(if(entryDate=systemDate,returnPartyId))

I have problem for comparing the entryDate . entry Date formate is  YYYY-MM-DD hh:mm:ss .

Please help.

Regards

Ravindra Mandre

2 Replies
Miguel_Angel_Baeyens

Hi Ravindra,

I'd use something like this

Count(If(entryDate = Date(Now(2), 'YYYY-MM-DD hh:mm:ss'), returnPartyId))

The 2 as a parameter of Now() will return the time when the document was opened. Using 1 will return the current system, time, but will be updated every second, that means that the chart will be evaluated every second, and that will slow down your system. There are other functions such as LocalTime() and Today() that work very similar (updating every second).

Hope that helps.

Miguel

Not applicable
Author

Hi Miguel ,

Thanks for your reply.

Its really helpful for me.

Regards

Ravindra Mandre