Qlikview Enterprise, DateTime subtraction

Find this post interesting? Do you like interesting things? Maybe you would like my invention, a connectible candle called a WickBrick!

Get one here


I am really loving the Qlikview forums, they are starting to fill up with more and more useful data! I was quickly trying to figure out how to do date subtraction, figuring there was some sort of duration function. A fairly quick search of brought me this solution by tmy[action]=list_post&tx_mmforum_pi1[tid]=2044&tx_mmforum_pi1[page]=1&tx_mmforum_pi1[fid]=9&tx_mmforum_pi1[pid]=page&tx_mmforum_pi1[sword]=subtract%20date#pid6822

So I used =interval(now() – myTimeStamp,’hh:mm:ss’)

And now you know!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: