Qlik sense straight table measure color expression
talking about expressions, how can I refer the measure (column) itself into a color expression ?
In the above example, if "Sales" is a measure (let's say, "sum(sales_value)") what is the color expression used to alter background color ? Probably, "if(sum(sales_value)>100000,green(),white())". But if it is a more complex measure, could be possible refer itself with something like: "if([my_self]>100000,green(),white())" ?
Re: Qlik sense straight table dimension color expression
not exactly. In your example you have "if(Sum([Sales Margin Amount])/...". In my case I've a "pre-defined" and complex measure as column in my table (named "DoD pct."). I'd like to write my color expression with something like "if([DoD pct.]/...", in other words a way to refer the column I'm writing in the color expression, by absolute (column/measure name) or relative (e.g. "myself","this") id.