topic Re: List box with variable dependent background color in QlikView

List box with variable dependent background color

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to have a List Box Background Color to change, depending on a specified Variable value?

Re: List box with variable dependent background color

Anil_Babu_Samineni — Wed, 25 Oct 2017 15:45:55 GMT

Please make it clear about the business, Is that is interview question?

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 15:51:29 GMT

Hi Anil,

I don't understand your English, sorry...

Could you please rephrase your reply for making it easier for me to understand.

Thanks.

/Hans Kaminsky

Re: List box with variable dependent background color

Anil_Babu_Samineni — Wed, 25 Oct 2017 15:52:39 GMT

I am asking, Please explain in detail..

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 16:05:59 GMT

Aha,ok.

My variables can have the values 1 or 0.

When a specific variable has the value 1, I want the relevant List box background color to be green.

When the variable has the value 0, I want the List box background color to be grey.

Ok?

Re: List box with variable dependent background color

Anil_Babu_Samineni — Wed, 25 Oct 2017 16:18:18 GMT

Like this?

Re: List box with variable dependent background color

vishsaggi — Wed, 25 Oct 2017 16:20:39 GMT

May be this might help. There is not straight forward background color for listbox. Just use a different Style in Presentation tab and use Background button.

Read this:

how to change background colour of a list box

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 17:43:22 GMT

Hi, I wrote List Box, but what I really meant was TEXT BOX (sorry about that..!)

So, how can the background color of a Text Box dynamically be set depending on the value of a Variable?

(green when the Variable = 1, grey when the Variable = 0)

Re: List box with variable dependent background color

vishsaggi — Wed, 25 Oct 2017 17:46:18 GMT

Just use Background color of the text box and write expression like

= IF(vVariable = 1, Green(), LightGray())

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 17:59:58 GMT

Hi, I wrote List Box, but what I really meant was TEXT BOX (sorry about that..!)

So, how can the background color of a Text Box dynamically be set depending on the value of a Variable?

(green when the Variable = 1, grey when the Variable = 0)

List box with variable dependent background color

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 18:01:55 GMT

Your solutions works for a text object also 🙂 Thank you very much!

Re: List box with variable dependent background color

Anonymous — Wed, 25 Oct 2017 18:17:49 GMT

Hi,

Your solution works perfectly

Thank so much for your help!

BR/Hans Kaminsky

Re: List box with variable dependent background color

vishsaggi — Wed, 25 Oct 2017 18:18:57 GMT

No problem.

Re: List box with variable dependent background color

Anil_Babu_Samineni — Thu, 26 Oct 2017 01:54:15 GMT

Great, You got information.

For future, You may create with good explanation because in your initial thread i haven't seen anything related text box and after few replies you came with text box.. Good luck

Re: List box with variable dependent background color

Anonymous — Thu, 26 Oct 2017 17:54:48 GMT

Yes, and as I said I'm sorry about that!

By mistake I wrote List Box instead of Text Box (Text Object). I'm really sorry, but I am not perfect, maybe you are...