Expression Attributes

We all have endearing attributes. Even me. My most endearing attribute is my humbleness. And my calves. You're most endearing attribute? You're willingness to obey my every command. That's nice.

Qlikview allows you to apply custom formatting to expressions. Maybe you want a dashed line instead of a solid line. Done. Your line is too skinny? Don't be stupid. Make it fat. Black text is so boring. How about grey? Speaking of grey, if you can guess the number of grey hairs that I have, you win a prize. Not a good prize.

I'm pretty sure that I'm up for the Congressional Medal of Honor because of FortuneCookieBI. Now, that's a prize!

Conditional Columns

One of the big issues we deal with is the lack of space in our dashboards. We tend to busy-up things by squeezing too much into a limited space. Stop it! there's a better way.  It's like magic.

Trellis Charts

Don’t make a chart like this! I dare you to try to make sense of it. You can’t. I’m not even going to try to list its faults. But its biggest fault is that it makes me angry. You wouldn’t like when I’m angry.

We can fix it.

Training PP for 8/8

Link to the training PowerPoint on Actions:

https://docs.google.com/file/d/0B_5TC7G8rWdKNTJ2V0pYcWpxY3c/edit

List of Actions

A list of Actions and their descriptions:

https://docs.google.com/file/d/0B_5TC7G8rWdKajZWTlB0WFV6MWc/edit

$ Sign on your Axis

I don’t know how many times I’ve been asked how to put a $ sign next to the figures on the y-axis. My answer has always been the same: you can only label the axis, not the values.

My rule of thumb: Never mess with a Sicilian when death is on the line. My other rule of thumb, probably more appropriate in this situation: ‘No’ most likely means ‘Not yet’.

m*Sight Training

Link to the PowerPoint from today's training:

https://docs.google.com/file/d/0B_5TC7G8rWdKLWZJUVRNVnBBZDA/edit