Select Excluded

Many of you use buttons to select a list box item:

Did you know that you can easily select everything BUT an item?

Go to Previous Sheet

Many of you use buttons to navigate among your sheets. Have you ever wanted to create a button that takes you back to the sheet you came from?


Easy-peasy.

1. Create a new variable named vSheetFrom
2. On your button that takes you to the new sheet, add a Set Variable action. In the value box, type =GetActiveSheetId()
3. On the second sheet, create a button with a Activate Sheet action. In the value box, type =vSheetFrom

Save and marvel at your cleverness.

Expression Cheat Sheet

In the words of the venerable Donald Rumsfeld, "Learn to say 'I don't know.' If used when appropriate, it will be often."

But, more appropriately for this tip, “…as we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns -- the ones we don't know we don't know." Of course, as we know and the media is too dumb to know, Rumsfeld stole this from Joseph Luft and Harry Ingham’s Johari Window.

In that spirit, I’ve created an Expression Cheat Sheet. It’s basically a list of all (or almost all) of the expressions in the Qlikview help files, grouped in a way that you can browse by topic to find ways of displaying your data that you may not know about. 

Download the file from Google Docs: http://tinyurl.com/expressioncheat

Percentiles, Part Deux

This week’s tip might seem a little difficult. But, TRUST ME, take it one step at a time and you’ll be amazed at how easy it really is!

This technique is a great way to maximize your available space by using variables to change a chart for different looks at your data. Your users will be happy that you put the effort in. Also, it doesn’t have to be limited to percentiles. We can modify it to change your dimensions as needed.