Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jorn_vango
New Contributor III

Limit automatic filtering of data across your App

When selecting a data point in a visual in your App, all the other visualizations in your App are automatically filtered down to that data point.  E.g. select 1 sales person in a table and the scatter plot that sits next to the table on your sheet and that shows all sales people also filters down to that 1 sales person = 1 point on the scatter plot.

As a result, you loose the ability to see where the selected sales person's point is on the scatter plot; aka how he/she is doing compared to the other sales people in the company.

Is there a way in Qlik Sense to not get rid of all the other sales people's points/dots on the scatter plot, but instead, highlight the selected sales person?

1 Solution

Accepted Solutions

Re: Limit automatic filtering of data across your App

The feature that lets you ignore or modify selections in a given visualization (actually in the measure) is "Set Analysis". You can read more about it in the Help, books, here on the forums or Qlik Continuous Classroom

You can see some examples of the type of "focus filtering" you mentioned here Focus not Filter | Qlikview Cookbook

There is a QlikView example Search Recipes | Qlikview Cookbook to accompany the article, I'm working up a Qlik Sense version.

Basically, in your scatterplot measures you would add a Set Expression that ignores any SalesRep selection.  e.g.

sum({<SalesRep=>}Sales)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

3 Replies

Re: Limit automatic filtering of data across your App

The feature that lets you ignore or modify selections in a given visualization (actually in the measure) is "Set Analysis". You can read more about it in the Help, books, here on the forums or Qlik Continuous Classroom

You can see some examples of the type of "focus filtering" you mentioned here Focus not Filter | Qlikview Cookbook

There is a QlikView example Search Recipes | Qlikview Cookbook to accompany the article, I'm working up a Qlik Sense version.

Basically, in your scatterplot measures you would add a Set Expression that ignores any SalesRep selection.  e.g.

sum({<SalesRep=>}Sales)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

jorn_vango
New Contributor III

Re: Limit automatic filtering of data across your App

Thanks Rob.  That works, however, it would be nice if Qlik would highlight the selection.  With a good amount of sales people (dots) in the scatter chart, applying set analysis keeps all the dots there but it's impossible to know which dot is the sales person you selected in the other viz..

Re: Limit automatic filtering of data across your App

You can highlight selected using the color expression. See the "Graying data" sheet in the attached example qvf.

2018-01-09_11-11-25.png

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com/

Community Browser