Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to have this 3 satements to define the colour of my bares, but I'm getting the fllowing error "garbage after expression"
My code is the following:
IF(A = 0,(IF(FIELD=1, RGB(34, 156, 228),IF(FIELD=2, RGB(0, 0, 0), IF(FIELD=3, RGB(34, 156, 228),IF(FIELD=4, RGB(0, 0, 0),IF(FIELD=5, RGB(34, 156, 228),IF(FIELD=6, RGB(0, 0, 0)))))))))
//
=IF(A= 1,
only({<FIELD={1}>} RGB(120,120,120)),
IF(A=2,
only({<FIELD={2)>} RGB(120,120,120)),
IF(A= 3,
only({<FIELD={3} RGB(120,120,120))));
=IF(A2=4,
only({<FIELD={4}>} RGB(120,120,120)),
IF(A2=5,
only({<FIELD={"<=5"}>} RGB(120,120,120)),
IF(A2=6,
only({<FIELD={"<=6)"}>} RGB(120,120,120))
)));
Can anybody help me?
What are you expecting to do?
First Silcer (0,1,2,3):
- Value 0 selected - All the colours have the colour default:
IF(A = 0,
IF(Match(FIELD, 1, 3, 5), RGB(34, 156, 228),
IF(Match(FIELD, 2, 4, 6), RGB(0, 0, 0))))
- Value 1 selected:
Only bares from local 1 change to a new colour (green for example).
- Value 2 selected:
Only bares from local 1 and 2 change to a new colour (green for example).
- Value 3 selected:
Only bares from local 1 and 2 and 3 change to a new colour (green for example).
Second Slicer (4,5,6):
- Value 4 selected:
Only bares from local 4 change to a new colour (green for example).
- Value 5 selected:
Only bares from local 4 and 5 change to a new colour (green for example).
- Value 6 selected:
Only bares from local 4 and 5 and 6 change to a new colour (green for example).
I need to create two slicers because customers wants a slicer with 2 points, so I create this tricky solution to provide it two selectores in slicers.
Thanks!