Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT

QlikSense - refer to measurement

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?