Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to color a dimension green if the value in this dimension is accuring two times in another dimension.
Dim1: Validity, Dim2: Named Account
Validity, Named Account
ST, Loreal
MT, Loreal
MT, Cisco,
LT, Stabilo
I would like to color the Dim Named Account green if one account has the Validity ST AND MT.
I tried it with entering the Dimension and fill following formula in the "Text Color" Area of the Dimension "Named Account".
if(match(Validity,'ST') and match(Validity,'MT'),green())
Unfortunately this is not working, if just one first parameter if(match(Validity,'ST'), green()) it is working.
Does anybody know how to achieve this?
I have added a sample app, the single Account is now green due to the parameter match(Validity,'ST'), the question is how to do with an and-condition?
May be like this?
Expression:
=Aggr(NODISTINCT if(index(Concat(Validity),'ST') and index(Concat(Validity),'MT'),green()),[Named Account])
Go to expression >> Background color >> if(WildMatch(Validity,'ST','MT') , green())
Or you can write your own expression if(match(Validity,'ST') and match(Validity,'MT'),green())
Use-
if(WildMatch(Validity,'ST','MT'),Green())
I would like to color the Dimension and not the Expression.
This statement will color all ST and all MT green.
I would just like to color those which are (ST and MT together).
This statement will color all ST and all MT green.
I would just like to color those which are (ST and MT together).
Go to dimenssion>> Background color >> if(WildMatch(Validity,'ST','MT') , green())
Use concat first
=if(index(Concat(Validity),'ST') and index(Concat(Validity),'MT'),green())
=if(Dimensionality() = 1,
colormix1(Your expression, white(), RGB(252, 85, 67)),white())