Qlikview with Sqlite

I just used this ODBC driver http://www.ch-werner.de/sqliteodbc/

And then created a new ODBC and pointed it at my sqlite database, and then used a normal ODBC CONNECT inside of qlikview.

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/


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


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

And now you know!