Advertisements

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 http://wickbrick.etsy.com/

WickBrick

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 http://www.qlikcommunity.com brought me this solution by tmy

http://www.qlikcommunity.com/575/?tx_mmforum_pi1[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!

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: