topic List Box - Remove values with no data in QlikView

List Box - Remove values with no data

Mon, 08 May 2017 13:11:02 GMT

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.

Re: List Box - Remove values with no data

sunny_talwar — Mon, 08 May 2017 13:15:44 GMT

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)

Re: List Box - Remove values with no data

antoniotiman — Mon, 08 May 2017 13:30:49 GMT

Try Expression

Aggr(Region,Region)

Regards,

Antonio