Clippy’s cousin, Qlikky: QlikView Easter Egg

Qlikview has coded an Easter Egg into the application… here’s a cute one: a send-off on Microsoft’s often maligned Clippy. Thanks to Barry Harmsen at Qlikfix for pointing this out. A fun little easter egg that shows the boys and girls at QlikView R&D have a sense of humor. Entering the expression: =’qmem://<bundled>/Images/clippy.png’ into a text object ...

Using Color Functions and Variables to Set Chart Colors

You may have noticed when assigning colors to charts, they do not “stick”. That’s because the charts can’t have any missing elements in them. I’ve found two great posts on how to fix the colors, and make maintenance easier. Henric Cronström at QlikviewDesignBlog : It is not uncommon that users want specific products or customers to ...

Avoiding Fuzzy Images when Exporting Qlikview Charts

You know how when you paste Qlikview objects like that fancy bar chart into your PowerPoints, it displays fuzzy? For me, it was hit and miss and I always had to waste time figuring it out each time. Well, it’s all about paste special, people.  Tip of Hat to Barry. A short post today on ...

“Q” — Your Business Discovery (Qlikview) Personal Assistant 1

QlikView extension objects example with speech input and audio capabilities: Elif Tutuk of Qlikview created a great voice recognition application in Qlikview (or I should say voice recognition enabled application in Qlikview). She says: A couple days ago, we were talking about Siri at lunch. Siri is the intelligent personal assistant that is available on iPhone 4S. It helps ...

20 Quick Qlikview Tips Video

I recently came across a great video (1 hr) of great tips and tricks for Qlikview, by Bill Karp of Answersharks. Bill is a long-time Qlikview guy and actually graded my Qlikview certification application years ago. These tips range in suppressing the splash screen for Qlikview to documentation default properties settings to indent mode for ...

Perfect Your QlikView Data Model

Steve Dark at Quik Intelligence has published a blog posting on Perfecting Your Qlikview Data Model. Steve reminds us that Qlikview table associations are very difference from associative data model joins — read on: Getting your data model correct is critical to any QlikView development. This article gives advice on how you should approach this task ...

Preventing Circular References in Qlikview

Circular references are common when building a data model.  A circular reference in a data model means that there is more than one way QV can resolve a query across 2 tables. There are a few good ways to avoid circular reference issues when creating a data model: Merge tables in to a single table using ...

Qlikview Scripting Tips: Connection Strings and Variables 2

When building and testing a QV application, you will typically use a production database (or live EDW) or a test database. It’s helpful to have a variable switch in the script to allow you to easily switch back and forth between the test and prod server. QQQ blog has a great explanation of how to ...

Qlikview 9 Server with IIS on a Windows 2003 Server

Microsoft IIS is often used as the webserver to serve up Qlikview pages using Qlikview Server. QQQ blog has some good tips for configuration of the Qlikview Server using IIS. This is applicable for QV 9 on a Windows 2003 Server. If your installation is fairly simple (no alternate websites, etc.), you may want to ...

Qlikview Scripting Tips: Comments

Using comments in a Qlikview script is good coding practice. Makes code easier to read and to debug. Develop a style for comments, for instance at the start of every load section. Here are some good tips, from the QQQ blog: There are several ways to create comments in your script. // is for single ...
Follow

Get every new post delivered to your Inbox

Join other followers: