topic Re: Filter List Box in QlikView

Filter List Box

pgalvezt — Thu, 28 Jun 2012 21:00:03 GMT

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 — Thu, 28 Jun 2012 23:46:06 GMT

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

Best regards,

Tonial

pgalvezt — Fri, 29 Jun 2012 14:07:16 GMT

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 — Fri, 29 Jun 2012 14:35:05 GMT

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.