Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
breno_morais
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
Specialist II
Specialist II

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)

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

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)

View solution in original post

Jesh19
Creator II
Creator II

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.