Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hariprasadqv
Creator III
Creator III

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

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.

1 Solution

Accepted Solutions
jagan
Partner
Partner

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.


View solution in original post

3 Replies
sujeetsingh
Master III
Master III

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
Partner
Partner

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
Creator III
Creator III
Author

Thank you All.