topic Re: Listbox expression doesn't show up green when selected... in QlikView

Listbox expression doesn't show up green when selected...

hansdevr — Thu, 04 Aug 2016 11:47:13 GMT

I have made a listbox which contains an expression, so people can choose a range of possible amounts.

The listbox comes up nicely...

Problem is: when a range is selected, the selection doesn't turn green. I can't be de-selected either..

What am I doing wrong, anyone?

=if(([Netto sch.lst. doss.])>=500000,'€500.000 en meer',
if(([Netto sch.lst. doss.])>=400000,'€400.000 - €500.000',
if(([Netto sch.lst. doss.])>=300000,'€300.000 - €400.000',
if(([Netto sch.lst. doss.])>=200000,'€200.000 - €300.000',
if(([Netto sch.lst. doss.])>=100000,'€100.000 - €200.000','€0 - €100.000')))))

Re: Listbox expression doesn't show up green when selected...

Thu, 04 Aug 2016 12:08:00 GMT

Hi, It is because that is not an actual field in your list box. The best thing to do is to make a that expression into a field in your load script. see below

tableA:

Load

[Netto sch.lst. doss.],

if(([Netto sch.lst. doss.])>=500000,'€500.000 en meer',
if(([Netto sch.lst. doss.])>=400000,'€400.000 - €500.000',
if(([Netto sch.lst. doss.])>=300000,'€300.000 - €400.000',
if(([Netto sch.lst. doss.])>=200000,'€200.000 - €300.000',
if(([Netto sch.lst. doss.])>=100000,'€100.000 - €200.000','€0 - €100.000'))))) as [Netto schadelast Range]

.............

then use this field into your listbox.(also a best practice to do calculations in load script). This should do it.

Re: Listbox expression doesn't show up green when selected...

hansdevr — Thu, 04 Aug 2016 12:43:33 GMT

Good idea, gonna try that right away!

Re: Listbox expression doesn't show up green when selected...

hansdevr — Thu, 04 Aug 2016 12:48:11 GMT

You're right, of course. Sometimes the answer is so obvious, you just don't see it..