This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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',
Hope it helps you.
View solution in original post
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
Thank you All.