Qlikview with Sqlite

I just used this ODBC driver

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


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!