topic Re: Values not being displayed in listbox in QlikView

Values not being displayed in listbox

er_abhichandra — Fri, 04 Apr 2014 06:36:56 GMT

Hi,

I am creating an Year listbox, with expression IF(Year>2011,Year).

I am facing a problem that the Year 2014 is not being shown in the listbox, and there is a blank area in the list box which is selectable and selects the value 2014, but the value is not visible though.

The value exists and is shown as selected in the current selections box. Is this a bug in QlikView?

Screenshot attached.

Thanks,

Abhinava

Re: Values not being displayed in listbox

Fri, 04 Apr 2014 06:48:34 GMT

Check the attached one,It is showing correct

Re: Values not being displayed in listbox

nizamsha — Fri, 04 Apr 2014 06:57:33 GMT

post ur sample data so i can change that one and revert it back

Re: Values not being displayed in listbox

alexandros17 — Fri, 04 Apr 2014 06:58:28 GMT

Very strange, here there are some ideas:

1) try to resize the box with years

2) Are years numbers or strings? Try to IF(Year>2011,trim(Year)).

3) to verify that year exists (in the box) write: IF(Year>2011,trim(Year), '9999').

Hope it helps