I'm trying to apply a color expression that refers to the formula used in the measurement. I want this to be dynamic so that regardless of what expression is used in the measurement, it is also used color mix expression.
Measurement Expression:
Measurement = sum(value)
Color Expression:
Colormix( sum(value), max(aggr(sum(value),date)), blue(), white())
Trying to do this:
Colormix( [column1], max([aggr([column1],date), blue(), white())
In Qlikview you can refer to a column, like column(1) as a way to refer to a measurement, but I can't get that to work in Qlik Sense. Any ideas how I can do this?
