Discussion board where members can get started with Qlik Sense.
I want to create a conditional color format in a table, with many measures as columns.
Measure formulas are complex, so i would like to color format cells using a easy way to refer to it.
I know that I could use:
If(Column(x) > 1, Green(), Red())
But if I change de measure order the color format is going to be wrong.
Besides Column(x), is there another way to referente it in a way that I can change order or change formula and the color formating still ok?
dont worry about complex if you want to jumble columns
just use same expression dont use Column(x)
Thanks Channa, but I'm looking for if there is another way to do it, so I can change expressions without worring about changing color format rules.
This is for minimize chances of making mistakes.
If there is no other way I know I can put expressions in variables and use it for color format, but I'm trying to avoid it at this moment.
Any other ideas?