Advertisements

Qlikview with Sqlite

Posted on April 18, 2008 by mellerbeck

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.

Advertisements

Filed under: Qlikview | Tagged: , | 1 Comment »

Qlikview Enterprise, DateTime subtraction

Posted on April 18, 2008 by mellerbeck

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!

Filed under: Qlikview | Tagged: , , , | Leave a comment »