Label Expressions

This tip won't bring any money, but when you die, on your deathbed, you will receive total consciousness. So you got that goin' for you, which is nice.

Some peculiarities really annoy me. This is one of them...

Qlikview allows dynamic labels using expressions. So, when we have a table or chart that displays a rolling six months, the labels update with the data. This expression shows Mar 2012:

     =MinString({$<[TimeFrame.RelativeFiscalMonth] = {'Current Month - 6'}>} Calendar.MonthYear)

The problem is that a long, possibly very complicated, expression shows up in the Properties lists.