Browse Tags
art BI blog business software charts cloud Database data mining Data Warehouse design EDX emerging technology ERP ETech08 flat earth globalization Google in-memory Intel Interactive Analysis MPP music NY Times optimization Performance Powershell Publisher QlikView QlikView 8.5 QlikView 9 QlikView 10 QVD Salesforce.com SAP scalability scalable size sizing Spotfire storage supercomputer Tableau Vertica Visualization web designCategories
Blogroll
Site Tools
…apb Archives
- January 2012
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- October 2010
- September 2010
- May 2010
- January 2010
- July 2009
- April 2009
- March 2009
- December 2008
- November 2008
- September 2008
- August 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- May 2007
- April 2007
- March 2007
- February 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
Category Archives: QlikView
Low-Cost Data Analysis & Visualization: It’s Getting Better All The Time
Over the weekend I have revisited Tableau, enjoyed some success with MonetDB, tried to turn MySQL into a hundred million row data warehouse, been underwhelmed with Firebird, installed Greenplum and spent many frustrated hours with Talend Open Studio, Pentaho Kettle … Continue reading
Improving The Load Process With Multiple ODBC Connections
One of the most useful tricks shared at the QlikView conference was from Nik Boman on improving the data extraction from databases. ODBC is a slow protocol, running orders of magnitude slower than the database or a typical Ethernet connection. … Continue reading
How To Request A Ticket Using QlikView’s HTTP Server
My apologies for the code that was posted here. Copying and pasting broke the code. Download a ZIP of the code here. I have expanded on the demo code that was floating around at Qonnections 2008. That code included an … Continue reading
String vs. Numeric Comparisons
I don’t know if you use a lot of Sum-If logic like I do. It’s a blessing and a curse. For example: sum(if(Category=’Sales’,Amount)). It just doesn’t scale up to tens of millions of rows. Even with only a million rows, … Continue reading
Posted in QlikView
Leave a comment
Using QlikView Tickets
Starting in Server 8.2, QlikView authentication is much more flexible with tickets. I’m just getting started with them myself, and I’ll be sharing the resources I find along the way. Big thanks to Dan English, Johan Jeanson and Claes Linsefors … Continue reading
Posted in QlikView
Leave a comment
Faster Reloads With “Core Control”
QlikView is multi-threaded in many areas but not during the load process. Next time you’re running a load script, open the Windows Task Manager. If you have 2 cores, the processor usage will never go above 50%. You can to … Continue reading
Feedback For Expression Variables
My thanks to Henric Cronström for taking the time to review my post on expression variables. He said the name for this new feature is still being decided. And he had some valuable information for getting started. Your text is … Continue reading
Seeing Dollar Signs in QlikView 8.5
One of the more interesting features coming in QlikView 8.5 is “Dollar-Sign Expansion with an Expression”, Section 24.5 in the coming Reference Manual. One place in the manual they are called “on-the-fly variables”, but I prefer “expression variables”. In many … Continue reading