topic Re: list box grey colour in QlikView

list box grey colour

Tue, 15 Mar 2016 15:01:50 GMT

Hi all

When i open a sheet in qlikview, i want to make a value in list box to be in grey colour

Sheet1

list box

India

japan

china

i want china to be automatically grayed

Re: list box grey colour

nagireddy_qv — Tue, 15 Mar 2016 19:04:23 GMT

Hi John,

Go to sheet properties -- triggers -- sheet event triggers OnActivateSheet and add an action.

This will automatically let you select one country on activating the sheet. If you want to change the color to grey you must check an extension objects that lets you pick own choice of color for selection.

Re: list box grey colour

its_anandrjs — Tue, 15 Mar 2016 19:07:29 GMT

What is the reason and condition you want the china to be display as grey.

Please elaborate more about this.

Regards

Anand

Re: list box grey colour

amayuresh — Wed, 16 Mar 2016 04:51:33 GMT

Try this,

Set Trigger on 'OnActiveSheet' Event of sheet1 as

Action = 'Select in Field'

Field = 'Country'

Search String = (India|japan)

China will Automatically grayed

Re: list box grey colour

Wed, 16 Mar 2016 05:21:11 GMT

very simple when i open a document or sheet i want this china should be automatically greyed out

Re: list box grey colour

Wed, 16 Mar 2016 05:21:29 GMT

very simple when i open a document or sheet i want this china should be automatically greyed out

Re: list box grey colour

Wed, 16 Mar 2016 05:22:17 GMT

very simple when i open a document or sheet i want this china should be automatically greyed out

Re: list box grey colour

amayuresh — Wed, 16 Mar 2016 05:38:18 GMT

Another option: Do such a selection in another list for which China is not associated.