Qlikview – Connecting to Essbase

Qlikview – Connecting to Essbase Qlik has an Essbase connector that can be downloaded at Qlik’s customer downloads website: http://us-d.demo.qlik.com/download Here are the steps to help you get qlikview connected to essbase. Open a new or existing QlikView app and select Edit Script... from the File menu. Select the Essbase (QvEssbaseConnector.exe) Connector from the drop-down…

Read More

QlikView: Custom Pop-up Labels

Let’s say I have a grouped chart with two expressions, Sales and Costs. I like the look of this chart, but there’s more information that can be provided to tell a better story, such as Margin and Margin %. So how can I add the additional information without altering the look of my chart? Custom…

Read More

Qlikview – Copying Objects and Expressions

Copying an Object Often time’s objects within a qlikview application are either reused or reused with minor changes, in other qlikview applications. This can be a time consuming process to recreate several of these objects. This can be done much faster. Simply, copy the existing object and make the necessary changes. You can copy sheet and chart…

Read More

QlikView: Nested If Statements

It is best practice to design QlikView apps (or any BI application for that matter) in a way that presents the information in a clear and concise manner, so that users can spend their time and energy on analysis rather than wondering what it is they are actually looking at. Here is an example. I…

Read More

QlikView: Using Alternate States for Comparative Analysis

Alternate states allow users to make different selections on the same dimension, which can be very useful when performing comparative analysis. In the example below will be comparing sales between two countries, and to go a step further we will also be able to compare sales people with one another to get an idea of…

Read More