It’s often useful to avoid repeating lengthy expressions. Here’s one technique for reusing expressions.
Let’s add another column for “Commission”, defined as 10% of Net. Instead of repeating the Net calculation, use the expression:
=Net * .1
Qlikview allows referencing the value of another column in the same chart by name. The name is the value assigned to the column label. “Net” in this case is not a Field. It is a symbolic reference to an expression. It may be used in other expressions in the same chart, but not in places where a Field name is expected.
=Net / 2 Allowed
=Sum(Net) Not allowed
Column references can be very useful in Expression attributes. Let’s bold any Commission value over $200. We’ll use a Text Format expression of:
=if(Commission > 200, ‘<B>’)
giving this result: