topic Re: how to keep graph detached from other objects in QlikView

how to keep graph detached from other objects

Tue, 21 Jan 2014 14:33:21 GMT

I have a sheet with several graphs where each graph shows a catagory of the data and a table box which covers all categories of data. I want the graphs to always stay full of all the data for their category and when I make selections in my table I want just the table to colapse and show only the selection while the graphs remains as a pictoral reference of the whole data environment. When I right click on the graph and select "detach" from the pull down I get the desired result but only while that graph is displayed. as soon as I minimize the graph it looses its "detach" setting. How (or can) I make the "detach" setting stick until I choose to release it?

Re: how to keep graph detached from other objects

alexandros17 — Tue, 21 Jan 2014 14:35:31 GMT

Use Alternate states ...

Hope it helps

Re: how to keep graph detached from other objects

Nicole-Smith — Tue, 21 Jan 2014 15:12:28 GMT

If you want to ignore selections on certain objects, you can use {1} in set analysis.

Examples:

sum({1}Sales)

sum({1<Product={'Fruit'}>}Sales)

Re: how to keep graph detached from other objects

Tue, 21 Jan 2014 15:17:51 GMT

Go to Document properties -> General tab -> Alternate states (its between the button "Help Pop-ups" and "Memory statistics".

Choose add, and give it a name, for example "State1".

Now go to the properties of your chart -> general tab. In the middle at the top of this tab, you have the header "Alternate state". It's standard on "<inherited>". Change this to state you just created (in my example "State1").

The graph should now not be affected anymore to the selections you make in your tables, but alway display all data.

Re: how to keep graph detached from other objects

Tue, 21 Jan 2014 18:25:28 GMT

thank you very much for the detailed how-to