Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
surtex
Contributor III
Contributor III

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

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 🙂 

Labels (6)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
MendyS
Partner - Creator III
Partner - Creator III

 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
Contributor III
Contributor III
Author

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

MendyS
Partner - Creator III
Partner - Creator III

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.