topic Re: Colour List Box Items depending condition in QlikView

Colour List Box Items depending condition

Thu, 04 Jul 2013 10:55:54 GMT

Hi,

I need to use a listbox as a navigation pane and I need to be able to colour these items depending on a condition - eg, Red Background, Amber Background or Green Background. (so the user can 'drill down' an item depending on its score)

Is this possible ?? If not is threre a more suitable solution?

Im already using the expression to colour a text object :

=if(vPrevMonthScore<vCurrMonthScore,rgb(83,230,62), //Green

if(vPrevMonthScore>vCurrMonthScore,rgb(255,47,47), //Red

rgb(233,165,39))) //Amber

Ideally I would like to use this expression to 'colourise' the listbox

Any help and suggestions greatly appreciated,

Many thanks

Re: Colour List Box Items depending condition

Gysbert_Wassenaar — Thu, 04 Jul 2013 11:34:15 GMT

As far as I know that's not possible with listboxes. You could try if an extension object like the one mention here offers more options. Or you can try to create a fake listbox using a straight table. The disadvantage of the straight table is that it's not possible to select multiple items individually (ctrl+click) like in the listbox.

Re: Colour List Box Items depending condition

Thu, 04 Jul 2013 13:38:12 GMT

HI,

Thanks for your reply. I've gone for using a straight table chart and am trying to test the each of the dimensions against the expression.

With regard to this, are you able to help further? Do you have any advice on how to use the expression :

=if(vPrevMonthScore<vCurrMonthScore,rgb(83,230,62), //Green

if(vPrevMonthScore>vCurrMonthScore,rgb(255,47,47), //Red

rgb(233,165,39))) //Amber

to test each dimension in the straight table chart? eg:

Im guessing some Set Anaylsis is required - but unfortunately Im very new to QV.

Many thanks again for your help.

Re: Colour List Box Items depending condition

Thu, 04 Jul 2013 13:41:36 GMT

Go to expression Tab, Expand the Expression click on backround and put your desired condition over there.

Hope this will Help

Regards

Himanshu

Skype himanshu_sethi

Re: Colour List Box Items depending condition

Thu, 04 Jul 2013 13:48:08 GMT

Thanks for your reply. I understand how to change the dimension colour using an expression. My query is how to check the 'Score' for each individual dimension value in the list. If I add this expression to the dimension then the whole list turns 'Red'.

Thanks,

Re: Colour List Box Items depending condition

Thu, 04 Jul 2013 17:34:29 GMT

Same can be applied in dimmension as well, try the same in dimmension

Regards

Himanshu

Skype- himanshu_sethi