topic Selectively filter graphs on a page in QlikView

Selectively filter graphs on a page

Fri, 04 Sep 2015 11:18:36 GMT

I'm new to Qlik and I've been tasked with something that is above my beginner status. Below is a screen that has been filtered by "Owner" (Filter Box #1). What I need is to have Chart #2 NOT filter but display totals for all the Owners. The intent is to create a "challenge" showing each Owner where they stand against the others.

Any help is appreciated.

Re: Selectively filter graphs on a page

tresB — Fri, 04 Sep 2015 11:21:35 GMT

Try expression like:

Sum({<OWNER>} Amount)

It could be any other aggregation function in place of sum(). This is called Set Analysis, learn about it from help.

Re: Selectively filter graphs on a page

Fri, 04 Sep 2015 11:40:00 GMT

Thank you so much. That works perfectly.

Re: Selectively filter graphs on a page

Fri, 04 Sep 2015 11:42:40 GMT

I've used Set Analysis in other instances but I had a mental block on this one. Thanks again.