Discussion Board for collaboration related to QlikView App Development.
i have a sheet in which i'm using a filed country
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
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)
may be try expression in your list box instead of field like this?
This should work!!
Similarly on other sheets you can restrict other field values
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
in sheet 2, create the list box with expression
So in sheet 1 user will not be able to see the China in list box