Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

list box grey colour

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

7 Replies
nagireddy_qv
Contributor II

Re: list box grey colour

Hi John,

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

action.JPG

select.JPG

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

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

Please elaborate more about this.

Regards

Anand

amayuresh
Contributor III

Re: list box grey colour

Try this,

Set Trigger on 'OnActiveSheet' Event of sheet1 as

Action = 'Select in Field'

Field = 'Country'

Search String = (India|japan)

China will Automatically grayed

Not applicable

Re: list box grey colour

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

Not applicable

Re: list box grey colour

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

Highlighted
Not applicable

Re: list box grey colour

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

amayuresh
Contributor III

Re: list box grey colour

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