Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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())" ?
I'm using Qlik Sense 1.0.2
Thanks.
Hi Michael, I'm hoping that, other than measures and master items, color expression feature will be also extended to dimensions.
Regards,
Paolo.
It's possible to refer to itself with the column function. "If(Column(1)>10000,Green(),white())"
Column() returns the value found in the column corresponding to ColumnNo in a straight table, disregarding dimensions. For example Column(2) returns the value of the second measure column.
column(ColumnNo)
In my Qlik Sense 3.1 SR4 actually is possible to build the color expression by refer the label name of the straight table, but actually the check expression in the bottom don't recognize the name of the label and give you an error..
But the expression will work anyway..
Also possible to build a new expression with reference to an existing expression label. Also gives you an error, but it will work.