Filter List Box

[pgalvezt]

I have a list box with many enterprise and another list box with their codes:

In my straight table works as follows on the dimension tab: If(CodEmpresa='1' or CodEmpresa='2', DescripcionEmpresa)

The table shows me just the cod 1 and 2 but if I do the same exercise in the list box doesn't work.

Any help,

Thanks

[fernando_tonial]

Hi, i recomed create another field in data clound with this if.

Best regards,

Tonial

[pgalvezt]

Hi Fernando, If I understood well you mean create an artificial field like 'Field' as New Field? any case I put an example for better comprehension.

Thank you

[fernando_tonial · Accepted solution]

Hi,

See my exemple.

LOAD *, If(Match([Cod Emp],'1','2'), NameEmp) as NameEmpAux inline
[Cod Emp, NameEmp,
1,A,
2,B,
3,C,
5,D,
6,A,
7,A,
8,E,
9,F];

Best Regards.

Tonial.