topic AW:Re: AW:Re: AW:column is not affected by a particular filter in QlikView

column is not affected by a particular filter

Fri, 15 Apr 2011 21:37:07 GMT

Hi,
Is to make a particular column is not affected by a particular filter?
Example:
Sum ({$ <Metas.ANO_MES={'$(v_data_meta)'}>} Metas.META)
The resuIts not be affected when I click on the filter CFOP

AW:column is not affected by a particular filter

Fri, 15 Apr 2011 21:48:27 GMT

Hello Gleybson,

I suggest you to try this:

Sum ({$ <Metas.ANO_MES={'$(v_data_meta)'} , CFOP={'*'} >} Metas.META)

Regards, Roland

AW:column is not affected by a particular filter

Fri, 15 Apr 2011 21:52:46 GMT

Hi Roland, I tried that way too, but the result changes.
This column can not receive filter CFOP selections.

AW:column is not affected by a particular filter

Fri, 15 Apr 2011 21:57:49 GMT

Another thing, if I put in a joint analysis in lieu of $ works there, but the tire size forfunctioning well.
Sum ({1 <Metas.ANO_MES v_data_meta ={'$()'}>} Metas.META)

AW:Re: AW:column is not affected by a particular filter

Fri, 15 Apr 2011 22:06:49 GMT

Hi Gleybson,

can't believe that, sorry.

a) CFOP={'*'} means independence of the users selection of field CFOP.

b) the '1' instead of the '$'-sign at the beginning of your SET - expression means NO single selection is regarded.

AW:Re: AW:column is not affected by a particular filter

erichshiino — Fri, 15 Apr 2011 22:18:20 GMT

I'd use a different syntax:
In your case:
 Sum ({$ <Metas.ANO_MES={'$(v_data_meta)'} , CFOP={'*'} >} Metas.META)
you get everything on CFOP, but ignore nulls, dont you?
You can make it:
 Sum ({$ <Metas.ANO_MES={'$(v_data_meta)'} , CFOP= >} Metas.META)

Then you just ignore selection and get everything

AW:Re: AW:Re: AW:column is not affected by a particular filter

Fri, 15 Apr 2011 22:29:26 GMT

Hi Erich,

yes, this is also possible. But I had some trouble a few weeks ago with it when using it more then twice within one set-statement.

sum( {< VJahr=,VMonat= >} VRGBetrag)

works fine

sum( {< VJahr=,VMonat=, VMenge= >} VRGBetrag)

doesn't

BUT:

sum( {< VJahr={'*'},VMonat={'*'}, VMenge={'*'} >} VRGBetrag)

works fine (again)

So I prefer the '*'.

Regards, Roland

AW:Re: AW:Re: AW:column is not affected by a particular filter

Sat, 16 Apr 2011 02:34:15 GMT

hi,
thus CFOP =
It works the same way that taking the $ and put the number 1. That is, the dimensions do not respond to anything.
I try to select a size and click it continues to show everything.

AW:Re: AW:Re: AW:column is not affected by a particular filter

Miguel_Angel_Baeyens — Sun, 17 Apr 2011 19:03:17 GMT

Hola Gleybson, respondo en español,

Lo que indican tanto Roland como Eric es correcot, y hay una diferencia respecto del uso del "1" en análisis de conjuntos. Si lo que quieres es que la expresión que ya has indicado funcione independientemente de la selección que realices en el campo CFOP, entonces debería quedar como

Sum({< Metas.ANO_MES = {'$(v_data_meta)'}, CFOP = >} Metas.META)

Sin nada detrás del "=". Así es como la sintaxtis del análisis de conjuntos debe funcionar.

Por otro lado, en la expresión he eliminado el signo "$". La diferencia entre "$" o "1" (si no pones nada, se presupone el "$") es si se deben tener en cuenta las selecciones actuales que afectan a las dimensiones de tu objeto o no, en el momento de realizarse el gráfico. Si lo que quieres es que independientemente de lo que selecciones en el campo CFOP el cálculo sea el mismo, la sintaxis de arriba debería funcionar.

Espero que te sirva.