NPrinting Exporting Numbers as Text...grrrrr

At first, I was   (╯°□°）╯︵ ┻━┻   and   ლ(｀ー´ლ)  and   ಥ_ಥ  and just about became a
 ““”̿ ̿ ̿ ̿ ̿’̿’̵͇̿̿з=(•̪●)=ε/̵͇̿̿/̿ ̿ ̿ ̿ ̿’““  ! No matter what I did, NPrinting would export my darn tables as text! If it could only translate the values to numbers like I can translate text emoticons into feelings.

calculating...calculating...calculating...calculating...calculating...calculating...

At first, I was flipping tables and angry face and sad and just about became a crazed gunner! Then, I found and adapted an Excel macro that gave me a ヽ(´▽`)/  .

Text in Chart

In the early ‘70s, those of us on the bleeding edge of technology used calculators with LED read-outs. Not only could we easily figure out the product of 908 X 57, but we could covertly write naughty words! We cleverly hid them by making you look at it upside down! 5318008 hasn’t been the same since…

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!

Give your rows breathing space

This tip is about as easy as it gets, but it’s a great way to improve the look, feel and usability of your tables, especially if they only have a few rows. When you create a table, the default is to get something like:

The rows are mashed up and everything looks dense. To add some space, open the Chart Properties and go to the Presentation tab. At the bottom right, check the box ‘Wrap Cell Text’.

Bam! You have a table that feels much lighter: