Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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
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
Yeah i know but I don't know how I get include this forumla in my expression above..
to understand better what you mean,
can you send a photo with that bar chart?
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