Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Miguel ,
Thanks for your reply.
Its really helpful for me.
Regards
Ravindra Mandre