Qlik Community

Qlik Sense App Development

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

pnowicki
Contributor

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?

Community Browser