Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

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

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

Hi Miguel ,

Thanks for your reply.

Its really helpful for me.

Regards

Ravindra Mandre

Community Browser