How Display color codes for data buckets in List box!!!

[hariprasadqv]

Hi All,

How can we display color codes for data buckets in List Box. I have tried in Liat box Expression but not accurate.

Expression used for data buckets creation in List box: =dual(replace(class(Quantity,7000),'<= x <','-'),class(Quantity,7000))

Expression used in expression Tb of list for Color codes = if(RowNo()=1,'qmem://<bundled>/BuiltIn/led_r.png',if(RowNo()=2,'qmem://<bundled>/BuiltIn/led_o.png','qmem://<bundled>/BuiltIn/led_g.png'))

Here is an issue when i am selecting a value then that becomes row 1 so the color will be updated every time when we are selected a value in that field.

How can i maintain standard color codes for the data buckets.

  Thanks in advance.

[sujeetsingh]

There are many ways to achieve this output at UI few of them is

  - Using colour expression in the charts for respected Buckets

  - Using a defined data island for color  and mapping it to Buckets

[jagan · Accepted solution]

Hi,

Try like this

if(QUANTITY>=1000 AND QUANTITY < 7000, 'qmem://<bundled>/BuiltIn/led_r.png',

if(QUANTITY>=7000  AND QUANTITY < 15000, 'qmem://<bundled>/BuiltIn/led_o.png',

'qmem://<bundled>/BuiltIn/led_g.png'))

Hope it helps you.

Regards,

Jagan.

[hariprasadqv]

Thank you All.