Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a multi box where i have some fields(filters))(say for example 1,2,3,4,5) in it.
I have created a block chart as you see in the below image:
Now when i click a a fields in multibox the heat map colors changes as you can see in the below image:
Expression written in the background color is :
IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 11+12+13+14, Green(),
IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 15, LightGray(),
IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 16, RGB(255,128,0),
IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 17, RGB(255,128,96),
IF(SUM(DISTINCT [Ageing Buckets SortKey]) = 18, RGB(255,0,0),
IF([Ageing Buckets(Due in)] = 'Current - Due in >15 days', RGB(0,255,0),
IF([Ageing Buckets(Due in)] = 'Current - Due in 10 to 15 days', RGB(0,220,0),
IF([Ageing Buckets(Due in)] = 'Current - Due in 5 to 10 days', RGB(0,192,0),
IF([Ageing Buckets(Due in)] = 'Current - Due in <5 days', RGB(0,128,0),
White()
)))))))))
Now my requirement is even if i select any filter in the multi box the current color should come as "green" and "1-30 as grey". It shouldnot change to white.
Can you please tell me how to achieve this.
Thanks,
Bharat
Yes. Settu.. It is checked.. I have found the solution.. Thanks a lot...
u can use indicator
=if
(
Sum(
if(
Status = 'green',1
)
) > 0
,
'qmem://<bundled>/BuiltIn/led_r.png'
,
if
(
Sum(
if(
Status = 'grey',1
)
) > 0
,
'qmem://<bundled>/BuiltIn/led_y.png'
,
'qmem://<bundled>/BuiltIn/led_g.png')
)
Thanks Chanty for the reply. .But i need with the expression which i have written in the background color expression...
try
if(getcurrentselection(filter) >1,green(),lightgray())
Hi Bharat,
Did you try to check the 'Persistent Colors' option in the Colors Tab?
Yes. Settu.. It is checked.. I have found the solution.. Thanks a lot...
Thanks Chanty.. Found the answer..
cool how u did u done this?