Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in listbox should be able to be selected only certain values for example: prod1, prod1, ZERO. ZERO may not be indicated in listbox.
Regards Stefan
can this script also using also in a chart?
You want to display Fix values?
Hi stefen,
I can't get your requirement clearly can you please give some detail or please post your sample file
Thanks and Regards,
S.Amuthabharathi
Hi,
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..
Hi,
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
Use below:
If ( Len(ncc_focus)>0, ncc_focus, 'Unknown' ) AS ncc_focus
this should work.