topic Re: Filter Current Selection Except one Value in QlikView

Filter Current Selection Except one Value

cristian_av — Fri, 04 Aug 2017 14:53:26 GMT

I need to filter the one value from a Sum, but considering the current selection.

Actually, I'm using the following set expression, that excluded the value (ExcludedValue), BUT ignores the current selection on the filter.

=Sum({$<[Tipo Registro]={Real},code_nombre={'*'} - {'ExcludedValue'}>}Pesos

How can I exclude the value without ignoring the current selection??

Thanks!!

sunny_talwar — Fri, 04 Aug 2017 14:57:55 GMT

Try this

=Sum({$<[Tipo Registro]={Real},code_nombre -= {'ExcludedValue'}>}Pesos)

Note: Add the minus sign before the equal sign

cristian_av — Fri, 04 Aug 2017 16:18:49 GMT

Thanks.. but it's not working.. that gives me another value. (Not sure what means -= )

It is working. A selection was set and because of that the value changes (As expected.. dumb of me)