Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to subtract 2 dates but one of the fields sometimes has no dates. This gives me a strange result where I get a large minus figure such as -2174. How can I deal with this? This is the expression I have used:
resolution date - created date
Rangesum(resolution date, - created date)
Alt(resolution date, today(2)) - created date
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com