topic Ignore a filter in chart expression in QlikView

Ignore a filter in chart expression

Sun, 19 Sep 2010 18:13:44 GMT

Hi All,

Can I ignore a particular selection filter in a chart expression? So if I have an expression like Sum(Sales), and 5 different selection boxes, can I change this expression so that when one particular selection is made it is ignored, but the other four select as normal?

Thanks

Ignore a filter in chart expression

vgutkovsky — Sun, 19 Sep 2010 18:18:17 GMT

Yes, you can do this with set analysis. For example, if the field you want to ignore is called myfield, then the expression would be: sum({<myfield=>} Sales)

Regards,

Ignore a filter in chart expression

Sun, 19 Sep 2010 20:19:57 GMT

Great, thanks very much

Re: Ignore a filter in chart expression

phongnnguyen — Thu, 07 Jun 2018 10:08:16 GMT

Hi Vlad,

I have problem in this case. How to ignore currently filter when i use a variable: Aggr({1<BranchName=>}$(vInterest)) - it is not working

with "vInterest" is code below:

if((interval(min(TradeDate)-CreateDate_Branch,'d'))>0,

sum({<BranchName=>}if( k=0 and DebitInterest>0,DebitInterest))/count(distinct {<BranchName=>}TradeDate),

sum({<BranchName=>}if( k=0 and DebitInterest>0,DebitInterest))/NetWorkDays(CreateDate_Branch,max(TradeDate)))

My purpose is how to display all Branch in Bar chart when I filter just a Branch of them. Right now, it is just display a chart which is selected

Thanks so much for your help