The QlikView Blogroll

I forget: what’s in memory?

Quick - Qlear - Qool — Thu, 02 Sep 2010 13:21:30 GMT

I’ve came across an excellent post by Boris Evelson on his blog: http://blogs.forrester.com/boris_evelson/10-03-31-i_forget_whats_in_memory (thanks to @vizubi) it’s an old one, but it makes perfectly clear what are the differences between...(read more)

Listbox or Multibox for Group of Things That Satisfy a Condition

QlikView Maven — Wed, 01 Sep 2010 20:06:00 GMT

The expressions that I wrote about in my last blog post can also be used in a listbox or multibox . For example, the expression =If(aggr(rank(sum(SHIPMENTS)),ITEM) Which lists the 15 top ITEMs by shipment volume, can be put into a listbox where it will...(read more)

Calculated Dimensions to Show Things Satisfying a Condition

QlikView Maven — Mon, 23 Aug 2010 19:52:00 GMT

We often use a Cycle Group for the dimension on our charts. That allows the report user to switch between different dimensions easily. I’ve found it useful to add a few extra calculated dimensions that only show a particular group of things – a group...(read more)

Installation ended prematurely because of an error

Qlik Tips — Tue, 10 Aug 2010 10:48:00 GMT

I had started having this problem recently and decided to blog the solution because I couldn't find it elsewhere. This was happening when I went to install QlikView 9 SR5 but it is actually an issue with the Wise installer rather than QlikView specifically...(read more)

Commenting out an entire Load or Select statement

BI Commons » QlikView — Wed, 04 Aug 2010 14:58:27 GMT

Rather than using double slashes (//) on all lines of a Load or Select statement or opening and closing comments (/* */) before and after, typing rem comments the script until it reaches a semicolon. For instance: SalesFact: LOAD Date, CustID, Amount...(read more)

Can I really replace a data warehouse with…nothing?

Picture Results, A US-Analytics Blog » QlikView — Tue, 27 Jul 2010 20:14:13 GMT

Here's the interesting reality. You don't need a data warehouse. And you do. And sometimes something in the middle works just fine. How can this be? Well, simply because...it depends....(read more)

It’s Technical: Year-over-Year comparisons using Set Analysis and Cycled Expressions

Wipfli: Blog: QlikThoughts — Tue, 27 Jul 2010 00:00:00 GMT

How to display data from the current year against the same or related data from the same period last year....(read more)

Export Data From QlikView Table

QlikView Maven — Fri, 23 Jul 2010 15:34:00 GMT

If you have a QlikView document already loaded with data you can export the data from any of the QlikView tables inside the document to a file. The file can either be a comma-delimited text file or a .qvd file. From the menu, choose File->Edit Script...(read more)

Select Top Ten ITEM Values

QlikView Maven — Wed, 14 Jul 2010 22:34:00 GMT

I've mentioned several times the kind of expression that you can enter into a listbox or multibox to make QlikView do more complex selections than just clicking on values. Those expressions that you begin with an equal sign , = , are actually advanced...(read more)

Stepping a Selection Through Each Value of a Field

QlikView Maven — Fri, 09 Jul 2010 18:20:00 GMT

Two years ago I posted an entry in this blog describing a macro that would let you step through all of the values of a field. The macro would successively select each value of a field. Shortly after I posted that entry the need for it became obsolete...(read more)

Version Control support is comming in QlikView 10!

Guerrilla Business Intelligence - your savior in the BI jungle — Fri, 09 Jul 2010 08:56:33 GMT

Ohh My God! A year ago I submitted this feature request for 10: >>When doing a more "professional" developing it would be nice to do version control and be able to track development done by the different project members... I don't...(read more)

The Now() Trap

Qlikview Notes — Thu, 08 Jul 2010 16:18:00 GMT

The Now() function operates differently in script and charts. This post will highlight one difference that has tripped up even experienced developers. Our example script requirement is to extract rows of data where the " TransactionDatetime "...(read more)

How to test if a variable exists or not

Guerrilla Business Intelligence - your savior in the BI jungle — Wed, 07 Jul 2010 08:28:46 GMT

From my year coding PHP I've always missed the Handy isset function to check if a variable isset. But its actually possible to use the isnull function to do the same in the script. Just remember not to use $ sign expansion! Since this will evaluate...(read more)

Fire a Trigger When User Changes an Input Field

QlikView Maven — Tue, 06 Jul 2010 17:56:00 GMT

Prior to the introduction of Input Fields there was no need for a trigger that would fire when loaded data changes. Because the only way that data could change was to reload it. But, when the QlikView document uses input fields then some of the data can...(read more)

QlikTech IPO: shares between $8.5 and $9.5

QVApps Blog — Wed, 30 Jun 2010 09:38:43 GMT

According to the QlikTech SEC filing of yesterday Qliktech will be offering 11,200,000 shares of its common stock during its IPO. The price range mentioned in the filing is between $8.5 and $9.5. With an average price of $9 QlikTech expects net proceeds...(read more)