in listbox should be able to be selected only certain values for example: prod1, prod1, ZERO. ZERO may not be indicated in listbox.
can this script also using also in a chart?
You want to display Fix values?
I can't get your requirement clearly can you please give some detail or please post your sample file
Thanks and Regards,
Empty/Null values are not shown in the list box.
hence you cannot select them.
However, you can use techniques like NullInterpret and NullDisplay to assign meaningful strings to Null value and then can select them in the List Box.
Hope this solves your doubt..
Please try this IF(IsNull(field) or field=' ',Unknown,Field) AS Field
then you can get the empty values with the name unknown in list box. I hope it helps you
It doesnt work? Garbage after expression "AS" NULL should be not listed in the box.
IF(IsNull(ncc_focus) or fncc_focus=' ',Unknown,ncc_focus) AS ncc_focus
If ( Len(ncc_focus)>0, ncc_focus, 'Unknown' ) AS ncc_focus
this should work.
Retrieving data ...