List Box - Remove values with no data

[#1]

Hello,

I want to create a list box and remove the values that dos not have any available data.  I have tried a few different formulas with no success.  For instance if AM Compliance doesn't have any available data I don't want it to appear in the list box.

[sunny_talwar]

May be create a flag in the script...

LOAD If(Len(Trim(Field1&Field2&Field3.....&FieldN)) = 0, 0, 1) as DataFlag,

          ....

FROM ....;

and then this as your calculated expression for list box object

Aggr(If(Max(DataFlag) = 1, Region), Region)

[antoniotiman]

Try Expression

Aggr(Region,Region)

Regards,

Antonio