Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

How to block filter selection by dimension

Hello,

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

Dimension:

REFERENCIA

grap.jpg

Any help?

1 Solution

Accepted Solutions
neelamsaroha157
Valued Contributor II

Re: How to block filter selection by dimension

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)

2 Replies
neelamsaroha157
Valued Contributor II

Re: How to block filter selection by dimension

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)

jeshwanth19
Contributor II

Re: How to block filter selection by dimension

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.