0 Replies Latest reply: Jun 29, 2016 7:18 AM by Paul Nowicki RSS

    QlikSense - refer to measurement

    Paul Nowicki

      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?