How exclude the filter in the chart qlik sense

[pascos88]

Hello I have a bar chart where I compare two values.

I would like to blok this chart even if I use some filter.

the set expression in the Measure is the following:

=Rangesum(above(count({1}{<CampaignID={605900}>} DataUpd_Conf),0,rowno()))

this test with {1} doesn't work.

Some idea??

Thanks in advances

[jwjackso]

You could create an alternate state and on the general tab of the chart assign the state.

[sunny_talwar · Accepted solution]

Try this

=Rangesum(Above(Count({1<CampaignID = {605900}>} DataUpd_Conf), 0, RowNo()))