topic Re: Show or hide rows based on set analysis in QlikView

Show or hide rows based on set analysis

Anonymous — Fri, 10 Oct 2014 16:02:09 GMT

Hi all,

I would like to show an specific range of data in a table chart. The selection is done by passing values from another field, but the result is not the expected. So I thing something is wrong in the expression in the table. Any ideas?

Please find attached file.

Thanks.

Marc.

Re: Show or hide rows based on set analysis

carvalguil — Fri, 10 Oct 2014 17:23:56 GMT

Hi Marc,

Try the expression below

=only({1<CanaldeVentaId=p(TecnicoId), InicioContratoEjercicioMes=p([FInicio EjercicioMes]), TipoRelacion={'R'}>} Contrato)

Guilherme

Re: Re: Show or hide rows based on set analysis

Anonymous — Fri, 10 Oct 2014 19:41:48 GMT

Guilherme,

It works fine. Thanks.

I tried now to add more info into the table, for instance TipoRelacion, but I can not avoid nulls.

Any idea with this?

Thank you.

Re: Re: Show or hide rows based on set analysis

Anonymous — Fri, 10 Oct 2014 19:45:35 GMT

Sorry, solved by myself.

Thanks.