List Box Rows Colors

[sspawar88]

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‌

[avinashelite]

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 .

[sspawar88]

Can you explain It?

[jonathandienst]

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

[vardhancse]

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.

[awhitfield]

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

[sspawar88]

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%.

[agni_gold]

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

[sspawar88]

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

[petter]

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