topic Re: How Display color codes for data buckets in List box!!! in QlikView

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

hariprasadqv — Thu, 18 Jun 2015 05:12:49 GMT

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.

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

sujeetsingh — Thu, 18 Jun 2015 05:16:07 GMT

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

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

jagan — Thu, 18 Jun 2015 05:23:41 GMT

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.

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

hariprasadqv — Thu, 18 Jun 2015 05:41:14 GMT

Thank you All.