topic How to block filter selection by dimension in QlikView

How to block filter selection by dimension

breno_morais — Wed, 29 Aug 2018 18:09:33 GMT

Hello,

I have this chart and need to show total REFERENCIA witihout the filter change it.

Dimension:

REFERENCIA

Any help?

neelamsaroha157 — Wed, 29 Aug 2018 18:27:09 GMT

use REFERENCIA= in your set analysis expression.

For example if you r expression is sum(Amount) then you can convert it to -

Sum({<REFERENCIA = >}Amount)

Jesh19 — Wed, 29 Aug 2018 18:36:28 GMT

Put the filters in your set analysis which you doesn't want to have impact on the chart.

Let's say:

If you doesn't want to have an impact when filtering the values on YEAR, Month, Quarter fields. Try it as below:

=Sum({<YEAR=, Month=, Quarter=>}[Total de Ativos])

Else, if you are having too many filters and you want to achieve the same scenario, you can go with Alternate States.