Ignore a permanent filter for one KPI in bar chart (set analysis)

[surtex]

Hey Qlik Member,

I have a bar chart with 5 KPI's and a permanent filter.. but I would like to show 1 KPI which is not react on the current filter.

Anybody know a solution for the following expression?

Sum({<"Profit_Center**" = {'185','186','187','188','189'}, Company_Code = {'1940', '2050', '2350'}, Year={$(=Year(today())-1)}>} Cost_Center_Amount)*(-1)/1000

In this formula I want to ignore the filter....

The filter is a Month.Year filter..

Thanks 🙂 

[MendyS]

 Hi @surtex 

if you want to ignore from specific filter try to use with Count({<FieldName=}> Mesure),
hope that I got you correct, if not let me know

[surtex]

Yeah i know but I don't know how I get include this forumla in my expression above.. 

[MendyS]

to understand better what you mean,
can you send a photo with that bar chart? 

[vinieme12 · Accepted solution]

as below

Sum({<"Profit_Center**" = {'185','186','187','188','189'}, Company_Code = {'1940', '2050', '2350'}, Year={$(=Year(today())-1)},Month.Year=>} Cost_Center_Amount)*(-1)/1000