topic Ignore selections from a chart in QlikView

Ignore selections from a chart

john_duffy — Tue, 08 Feb 2011 16:41:01 GMT

Hello.

I have a request from our users to make selections from one chart which in turn determines what is displayed on a second chart. This piece is very simple because the data for both charts comes from the same table.

The challenge is that they do not want the data in the first chart to change.

I have attached a sample application to illustrate this request. On the left side, is the set up the user wants:

Select a report hours value from the Report Hours list box, select 1 or 2 users from the Dept < 30 hours chart, the 1 or 2 users are to be displayed in the Details chart, however, all users meeting the Report Hours condition are to remain displayed on the Dept < 30 hours chart.

On the right side of the tab is a work around. I cannot simply detach the Dept < nn hours chart because the user wants to be able to select values from the Report Hours list box to control what is displayed on the Dept < nn hours chart.

Is it possible to accomplish the user's request?

Thanks for your help,

John.

Ignore selections from a chart

Tue, 08 Feb 2011 16:51:42 GMT

Hi,

I attached a solution

Hope this helps

Best Regards

Ignore selections from a chart

john_duffy — Tue, 08 Feb 2011 17:15:38 GMT

Thanks for your response Gabriela.

Your solution will allow the Dept < nn hours chart to remain unchanged when a user(s) is selected, however, the Dept < nn hours chart also is not changing when the Report Hours is selected from the Report Hours list box.

For example, if I select 20 in the Report Hours list box, the Dept < nn hours chart should only show rows with an hours value < 20.

Any ideas? Note: We are using QV 8.5.

Thanks,

John.

Ignore selections from a chart

prieper — Tue, 08 Feb 2011 17:21:34 GMT

Users may "Detach" the chart?

HTH
Peter

Ignore selections from a chart

john_duffy — Tue, 08 Feb 2011 17:32:38 GMT

Thanks for the reponse Peter.

I did discuss this with the users, however, they will have to attach and detach each time the need to select a Report Hours value from the list box. They would prefer to not have to do that if possible.

Ignore selections from a chart

matt_crowther — Tue, 08 Feb 2011 17:44:49 GMT

John,

Cowboy solution attached - yee haw!!

This may fit your requirements - I've fixed the sort orders of both the users listbox and the first chart allowing you to make selections in the listbox as in your workaround but they appear to be being made in the chart as I've formatted and overlaid the listbox & chart...as I said 'Cowboy'.

As long as you maintain the sort orders you should be fine even if more users are added as both the chart & listbox will grow together.

I've also removed the option to move the objects so they'll stay aligned.

Other than this solution you're looking to break a fundemental of Qlikview: 'click something to select it' eg; clicking a line within a chart will select it; thus excluding other values (excluding Set Analysis etc).

***Should also add: use an if() expression in the listbox to control which users to display inline with your 'Report Hours' selections.***

Hope that helps,

Matt - Visual Analytics Ltd

Ignore selections from a chart

Tue, 08 Feb 2011 17:48:24 GMT

Hi,

Hope this solves the problem

Regards

Ignore selections from a chart

matt_crowther — Tue, 08 Feb 2011 18:02:05 GMT

John,

Gabriela's solution's better than mine no question.

All the best,

Matt

Ignore selections from a chart

john_duffy — Tue, 08 Feb 2011 18:44:14 GMT

Thanks again Gabriela.

That is exactly what I what I need.

John.