topic Re: List Box Rows Colors in QlikView

List Box Rows Colors

sspawar88 — Tue, 02 Jun 2015 05:06:10 GMT

Hi,

In My Application set analysis result in 1% to 100%.

Which i shown in three colors >51-->Red, <75-->Yellow, <100--> Green

but for achieve this it takes too long set analysis.

Now i want to give one list box which contains three rows of this three colors red, green, Yellow.

so that when i click on one color it will associate related results. e.g Red--> <51, Yellow--> <75 , Green--> <100

How can I achieve this ?

App Development New to QlikView‌ QlikView‌

Re: List Box Rows Colors

avinashelite — Tue, 02 Jun 2015 05:12:40 GMT

yes you can achieve this,

for the values range create an interval in the script and then match your values with this interval that should do .

Re: List Box Rows Colors

sspawar88 — Tue, 02 Jun 2015 05:15:20 GMT

Can you explain It?

Re: List Box Rows Colors

jonathandienst — Tue, 02 Jun 2015 05:48:39 GMT

Are you asking for help with: but for achieve this it takes too long set analysis.

or Now i want to give one list box?

You cannot have a list box with different colours, unless you create images in these 3 colours and then info load the images into your document. Or you can simulate this using a straight table with a 3 valued dimension and colour coding of the dimension values. If you want detailed assistance, I suggest that you post a sample.

Preparing examples for Upload - Reduction and Data Scrambling

Re: List Box Rows Colors

vardhancse — Tue, 02 Jun 2015 05:56:51 GMT

I think instead of list we can do it in list box,

List box->Properties->General<tab>->color

Here we can pass the expression so that based on the condition the color of text object can be displayed.

Re: List Box Rows Colors

awhitfield — Tue, 02 Jun 2015 08:47:29 GMT

You can't do it with a list box, but yo can elsewhere, see straight table example with conditional background colour:

=If(Value <=50, Lightred(),If(Value <=75, Yellow(),LightGreen()))

HTH Andy

Re: List Box Rows Colors

sspawar88 — Tue, 02 Jun 2015 10:22:48 GMT

Hi Jonathan ,

i want following list box in my application.

it should not show any value only colour.

and each colour has its own condition.

My existing application has set analysis which results in 1% to 100%.

Re: List Box Rows Colors

agni_gold — Tue, 02 Jun 2015 19:34:40 GMT

go for ColorMix function , please read about , you can achieve that.

Re: List Box Rows Colors

sspawar88 — Wed, 03 Jun 2015 09:05:19 GMT

Actually i'm working in Qlik sense..there is no staright table there. How can achieve this? any idea?

Re: List Box Rows Colors

petter — Wed, 03 Jun 2015 09:08:46 GMT

The standard or regular table i Qlik Sense is a Straight Table more or less