Multiple Selector with Calculated Dimension not showing field in green

microwin88x — Fri, 14 Mar 2014 18:04:14 GMT

Hello!

I have a calendar (from xxx date / to xxx date) and multiple selection fields:

The multiple selection fields (for example: Zona, Partido, Localidad, Oficina) are a calculated dimension

Example for Oficina: =IF(ID_TIE_FECHA# >= '$(vFechaDesde)' AND ID_TIE_FECHA# <= '$(vFechaHasta)',OFICINA)

>>> That is to use the calendar when I select dates.

The thing is that when I select a value IN A CHART (or somewhere outside the multiple selector) it doesn't selects in green in the multiple selector, as you can see in the following image:

I believe it has to be with the calculated dimension defined in the multiple selector. Is there any way to automatically select the corresponding value?

Thank you!!!

Re: Multiple Selector with Calculated Dimension not showing field in green

Nicole-Smith — Fri, 14 Mar 2014 18:23:44 GMT

Try changing your dimension to:

aggr(only({<ID_TIE_FECHA#={'>=$(vFechaDesde)<=$(vFechaHasta)'}>}OFICINA),OFICINA)

Re: Multiple Selector with Calculated Dimension not showing field in green

microwin88x — Fri, 14 Mar 2014 18:53:59 GMT

Thank you!!! It worked!!

topic Re: Multiple Selector with Calculated Dimension not showing field in green in QlikView

Multiple Selector with Calculated Dimension not showing field in green

Re: Multiple Selector with Calculated Dimension not showing field in green

Re: Multiple Selector with Calculated Dimension not showing field in green