topic Set Analysis And confusing Current Selection Box in QlikView

Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 00:57:52 GMT

Hi all

I now have my graphs working beautifully - using Set Analysis they do not change when a particular dimension is set.

However ... the Current Selection Box is confusing because it will show the selections that have been made in other screens. What is the best way of doing this to "grey" out the selections that have no effect?

Re: Set Analysis And confusing Current Selection Box

sunny_talwar — Thu, 31 Dec 2015 01:02:24 GMT

Grey them out in the current selection box or in the list box itself?? Not sure what you are looking to do

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 01:09:03 GMT

I can change the Classification for example - but it is confusing because my graph (using set analysis) is set up to respond only to the set Classification.

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 01:10:50 GMT

Other screens? Do you mean other sheets?

All listboxes and charts on all sheets operate on the same set of fields and tabres (the "data model"). Selections are common to the enitre document, including reports, sheets and all visible objects.So a Current selections object on sheet 20 will reflect selections you make on sheet 1. That's how QlikView works..

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 01:15:02 GMT

Set analysis produces cureent-object-only exceptions to normal selections that are common toi all objects. Set analysis usually only impacts expressions, not selections as such. It may even be that your common selections are taken into account in your set analysis (like "remove ABC frolm the current selection")

A current selections object only reflects common selections, like "green" values in listboxes and dimension selections

Re: Set Analysis And confusing Current Selection Box

krishna20 — Thu, 31 Dec 2015 01:16:56 GMT

Hi,

If i understand your requirement ,If you don't want see the current selections in other sheets.create trigger as clearall when sheet opens.

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 01:19:51 GMT

Hi Peter,

but using Set analysis you can make a chart or a text box show only the results of a filter.

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 01:23:06 GMT

Indeed.

But a set analysis filter is not necessarily controlled by selections. Set analysis often imposes a fixed set of filter values.

I think you should consider set analysis as a set of exceptions to common selection filtering. Set analysis tries to evade somehow the common mechanism of "filtering by interactively making selections".

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 01:23:33 GMT

I want to see the selections made in other sheets, but I do not want to confuse the user - the graph will say CLASSIFICATION = CLINICAL, this will not change as I have used {$ <Classification ={ 'Clinical'}> etc. However if another Classification has been chosen in another sheet - the Current selection box shows a different Classification.

Maybe I could create a trigger which will change the Classification on entry to the page?

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 01:28:26 GMT

It works if I put the trigger so that when the page opens - the Classification is set to 'Clinical' - that way the user is not confused by looking at the Current Selection Box. I think this might be the best way to avoid the confusion of the graph doing one thing and the Current Selection Box saying another.

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 01:29:20 GMT

IMHO the best thing you can do is to notify the user of set analysis "forced" selections.

What I propose to my customers is to specify fixed set analysis filters in the caption of every chart where set analysis has been applied. In your example, this would result in a caption "Graph XYZ (CLiNICAL classification only)"

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 02:13:27 GMT

That is a good idea ...

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 02:17:52 GMT

and that leads me to another visualisation question: I have the charts in a container and the container then shows the caption on the chart - but ... maybe I could keep the container caption and change the chart caption ... YES!!!!! I can do that.

Thank you Peter

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 02:23:03 GMT

Well, it stems from the simple (and economical) truth that you/we should let QlikView do what it does best: propagate selections to the far corners of a (often complex and bulky) data model and produce results "as if by magic". Whatever we try to twist and turn this streamlined mechanism into something else will sooner or later turn against us. I may oversimplify the reasoning behind this at the moment (being 3:30 at night overhere), but I think you get the idea.

Re: Set Analysis And confusing Current Selection Box

Peter_Cammaert — Thu, 31 Dec 2015 02:25:47 GMT

Great!

Good luck, and have a great new years eve.

Re: Set Analysis And confusing Current Selection Box

josephinetedesc — Thu, 31 Dec 2015 02:31:01 GMT

Thank you – same to you – it is 13:30 here heading for 39 degrees here – so it will be a hot start to the New Year!