topic AW:Re: transfer Quicken data to QlikView ? in QlikView

transfer Quicken data to QlikView ?

mschreiber — Wed, 28 Apr 2010 20:31:44 GMT

Hello,

do anyone use Quicken, the software solution for financial administration and bank account ?

I want to analyse my transactions from Quicken 2010 in QlikView. I found only a way to export to a QIF format, but this structure I can't import to QlikView.

Anyone a solution or an idea for this ?

Bye

Mathias

transfer Quicken data to QlikView ?

Wed, 28 Apr 2010 22:16:37 GMT

Mathias,

Check this page: http://quicken.intuit.com/support/articles/data-file-management/import-and-export/5989.html

Under the notes section, there is information about exporting to Excel, which QlikView should have no problem with

AW:Re: transfer Quicken data to QlikView ?

mschreiber — Thu, 29 Apr 2010 16:17:00 GMT

Jason,

thanks for the link - I checked it. The idea is good: creating a report in Quicken and export this to a spreadsheet. It will solve my problem. I was looking for a way to export directly, but this is another possible way.

Thanks a lot - bye Mathias

AW:Re: transfer Quicken data to QlikView ?

jlassell — Mon, 26 Jul 2010 20:01:40 GMT

Mathias,

Here is a QVW that will read a QIF file. It is intended only for "Bank" accounts -- not "Investment" accounts. I use Quicken 2008 right now and don't know if the QIF format is different for 2010. I don't have a "format" for the QIF file. I just used trial and error to figure out what the records lines referred to.

The key for me to create this was QlikView's PEEK command. It allows the file to be read into memory and then use another table but reference back to the original read to help determine "where you are" in the file.

Below is a Sample QIF file.

-Jeff

!Option:AutoSwitch
!Account
NBofA - Savings
TBank
D#22203-04995
^
NBofA - Checking
TBank
D#23822-04643
^
!Clear:AutoSwitch
!Option:AutoSwitch
!Account
NBofA - Checking
D#23822-04643
TBank
^
!Type:Bank
D2/ 4' 9
U200.00
T200.00
CX
POpening Balance
L[BofA - Checking]
^
D5/24' 9
U-8.95
T-8.95
CX
PBankOfAmerica
Mchecks
LChecks
^
D5/24' 9
U-80.95
T-80.95
CX
PPower Company
MMay
LUtilities
^
D3/15' 9
U495.64
T495.64
C*
PJoe's Sandwich Shoppe
LSalary
SSalary
$576.92
STax:Fed
$-15.15
STax:State
$-22.00
STax:Soc Sec
$-44.13
^
!Account
NBofA - Savings
D#23803-04643
TBank
^
!Type:Bank
D2/ 4' 9
U1000.00
T1000.00
CX
POpening Balance
L[BofA - Savings]
^
D2/ 9'10
U350.00
T350.00
CX
PVacation
LVacation
^

AW:Re: AW:Re: transfer Quicken data to QlikView ?

mschreiber — Mon, 26 Jul 2010 21:06:12 GMT

Hello Jeff,

I downloaded your qvw and created one qif export file for an bank account with my Quicken 2011. The QlikView script works well. I changed some small things, like the format of date (it is in the german QIF export format with delimiter . and not /).

I study your script and I must admit, that I not understand all commands. But so on weekend I will learn some new QlikView commands with your script. Thank you very much.
Mathias

AW:Re: AW:Re: transfer Quicken data to QlikView ?

jlassell — Mon, 26 Jul 2010 21:21:06 GMT

Gern geschehen!

You can email me directly at jefflassell@yahoo.com if you have any questions.

transfer Quicken data to QlikView ?

Sat, 07 Jan 2012 22:16:48 GMT

Hi Mathias,

can you share your last version of your file ?

Thanks

castrini@gmail.com

Re: transfer Quicken data to QlikView ?

mschreiber — Fri, 03 Feb 2012 08:20:19 GMT

Hello, attached the qifreader.qvw modified by me, working with german version of Quicken 2011.