Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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
Highlighted

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

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

Highlighted
Not applicable

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

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)

Highlighted
Not applicable

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

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

Highlighted
Esteemed Contributor

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

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

Highlighted
Not applicable

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

its not working

Highlighted

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

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

Highlighted
Not applicable

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

user wants to see china but this way