Twisting the knife in a useful pie chart

Some people think that pie charts will kill kittens and bring the downfall of western civilization. Some people (**deep breaths, be nice, serenity now, woosah**) love pie charts. Since my self control is only so strong, we won't mention 3D pie chart 'people'.

Everyone knows that I'm firmly in the first camp, but I'm nothing if not flexible and tolerant of other people's stupid viewpoints. Which brings me grudgingly to the fact that I've recently read a couple of posts that point out good uses of pie charts (Jorge Camoes & Francis Gagnon). The gist is that pie charts are good for part to whole comparisons. Please notice that 'part' is singular, not plural. Let's apply this to Qlikview.

You can't nullify machine guns and el Caminos

Someday I want to be badass enough to rescue a damsel in distress by shooting a machine gun from the hip while riding in the bed of an el Camino that's fishtailing through a dirt parking lot.

Until then, I'll have to settle for opening day of G.I. Joe: Retaliation and publishing awesome Qlikview tips. And being really, really, ridiculously funny.

I can't think of a clever way to tease this tip, but it will let you remove a value from a table, but still keep nulls. Here's the scenario:

We're displaying opportunity details in a straight table. One of the fields contains 'reasons for close'. One of those reasons is 'duplicate'. But since we want to show both open and closed opportunities that aren't closed because they're duplicates, we can't easily use set analysis since it won't gracefully handle the nulls.

To make this work, we'll create three variables, a calculated dimension and a button.

Maxed out

Today is Valentine's Day. Tomorrow you will be crushed by a 143,000 ton asteroid. It's worth almost $200 BILLION, so you should be able to rebuild your deck and get a new hot tub. Maybe even an name-brand Jacuzzi ! The only problem is that you only have a 1 in 3 Trillion chance of cashing in. Better if your house is bigger.

Movoto

While you're waiting, let's learn a new tidbit about the Max function.