Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table where I use the following expression with the {1} operator to prevent the data from changing when filter selections are made.
Count({1<Ex_Flag={'Excluded'},[HW Lifecycle Status] -= {'Disposed'}, [SW Lifecycle Status] -= {'Disposed'} >} SW_CI_ID)
This seems to work fine. But I also have the following expression in the background color of one of the dimensions to do some color coding.
=if((V_Class) = ('High'),rgb(255,0,0),
if((V_Class) = ('Medium'),rgb(255,217,47),
rgb(69,234,21) )
When I use make a filter selection, the data remains the same, but the background color coding changes/
How do I apply the {1} operator to the Background Color Expression?
Try this:
=If(Only({1} V_Class) = 'High', RGB(255,0,0), If(Only({1} V_Class) = 'Medium', RGB(255,217,47), RGB(69,234,21)))
Try this:
=If(Only({1} V_Class) = 'High', RGB(255,0,0), If(Only({1} V_Class) = 'Medium', RGB(255,217,47), RGB(69,234,21)))
That worked perfectly! Thanks Sunny
Hi Bobby,
it will be useful to mark it "answered"
Cheers
Antonio
Hi bobby mark correct answer and close this post...
Apologize for that!