Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box unnwanted values colour should be grayed on opening a document

Hi all

i have a sheet in which i'm using a filed country

Country

India

Japan

China

There is no data asociated with china in my sheet so in default when user sees he should see only india and japan as possible selections and china should be grayed out

how can i do that

7 Replies
sunny_talwar

May be add a trigger to select those Countries where the data is available?

Not applicable
Author

on  sheet1, i show only india and japan data

on sheet2 i show only china data

so when i open sheet 1 china should be automitically grayed out (it indicates the user thata there is no chance of selecting china on sheet1)

Not applicable
Author

when i open a shhet or document i want this to happen china should be automatically greyed out

Anonymous
Not applicable
Author

may be try expression in your list box instead of field like this?

=if(Country<>'China', Country)

This should work!!

Similarly on other sheets you can restrict other field values

Not applicable
Author

its not working

Kushal_Chawda

Instead going through the triggers why you are not creating the custom list box with the values that you are needed.

in sheet 1, create the list box with expression

=aggr(if(match(Country,'India','Japan'),Country),Country)

in sheet 2, create the list box with expression

=aggr(if(match(Country,'China'),Country),Country)

So in sheet 1 user will not be able to see the China in list box

Not applicable
Author

user wants to see china but this way