topic Re: listbox entry when data is not present in QlikView

listbox entry when data is not present

VivenReddy — Mon, 04 Feb 2019 19:49:22 GMT

I've created a listbox that displays 1 checkbox based on the dataset. There are times when the listbox does not display when the value in the table is not present. I'd like the checkbox to appear greyed out when the data is not present. Is this at all possible?

See attached example. Remove inline data for car 5 to test scenario with missing data.

Re: listbox entry when data is not present

Vegar — Mon, 04 Feb 2019 21:14:17 GMT

Try

load car_id, manufacturer, origin inline [
car_id, manufacturer, origin
1,toyota, japan
2,volvo, sweden
3,bmw, germany
4,honda, japan

6, kia, korea
7, vw, germany
];

//5,cheverolet,usa


LOAD * INLINE [
    origin, Label
    usa, Made in America
];

See attached qvw

Re: listbox entry when data is not present

VivenReddy — Tue, 05 Feb 2019 00:17:16 GMT

Thank you Vegar. However even though the entry in the list box looks greyed out, it still allows you to make a selection. Is there any way to kind of lock the object so that no selectin can be made when its greyed out.

Re: listbox entry when data is not present

Vegar — Tue, 05 Feb 2019 04:28:40 GMT

Maybe you could try solving it with document triggers, locking the label field if it is greyed out.