Hide Archives

JQuery Toggle Drop Down Effect

jQuery is a pretty amazing JavaScript library. It allows you to do things with JavaScript that were, back in the day, pretty tough to pull off. Today I want to show you how to do a simple toggle drop down effect using jQuery. The first thing …

QlikView – Suppress Splash Screen

We spend so much time trying to make things run as quickly and efficiently as possible, but sometimes we just can’t help ourselves when it comes to self-promotion.

QlikView loves making things go fast; starting QlikView is another story. As if we were unaware that we had elected to launch QlikView, a several second “commercial” in the form of a splash screen has to tell us that we are one of the lucky ones.

As much as I enjoy using QlikView, I find the startup splash screen to be a bit of a nuisance.

The good news is, there is a VERY easy way to prevent the splash screen from being displayed during program launch.

Excel – Hide Records with Zeroes in Pivot Table Calculations

One of the most asked questions of beginning, and sometimes seasoned, pivot table users is “How do I hide the entries in a pivot table whose totals equal zero?” On first blush, this seems like an easy feat, but users quickly discover that it’s not as easy as predicted. There are ways to sort the source data and then exclude the entries with zero values, but that task of sorting and filtering the source data would have to be performed each time the source data is updated. This is not an appealing prospect.

There is actually a very easy way to not display pivot table records that equal zero.