topic Re: How to make a chart permanently detached ? in QlikView

How to make a chart permanently detached ?

Tue, 03 Jun 2014 10:49:22 GMT

Hi i am looking to make a chart permanently detached and no filters should be applied on it anytime. Also how to make the text "(Detached)" that appears in the charts title bar disappear ?

Re: How to make a chart permanently detached ?

MayilVahanan — Tue, 03 Jun 2014 10:54:01 GMT

Try like this

Chart properties -> General ->

Select the check box - Read Only.

Edit:

And also, use {1} in the expression. ex: sum({1}sales)

Hope it helps

Re: How to make a chart permanently detached ?

Tue, 03 Jun 2014 11:10:30 GMT

you can disconnect the chart then it will ignore all changes. you can achieve this by right clicking on it and select disconnect.

I hope this helps.

regards,

Re: How to make a chart permanently detached ?

ashfaq_haseeb — Tue, 03 Jun 2014 11:13:05 GMT

Hi,

you can even use alternate states and places this chart in different state.

Regards

ASHFAQ

Re: How to make a chart permanently detached ?

christian77 — Tue, 03 Jun 2014 11:17:00 GMT

Hi.

Detach is more like an user property. If you detach an object, it'll show the data that had exactly in the moment it was detached. From that point, filters won't change anything in that graph or object.

I've just made a test. I have detached an object. When I reload, it attaches itself again. .

If only a static object is needed, let's make a picture a leave it there forever. That's what detach means. It is another feature of Qlik.

In I would use markers, instead of detaching.

Using sum({1} Sales) is apossibility too. In that case you don't need to detach nor mark anything. It'll be always the whole thing.

You can use sum({EA01} Sales) also as an alternate state.

I hope it helps.

Re: How to make a chart permanently detached ?

christian77 — Tue, 03 Jun 2014 11:21:47 GMT

Anyway, you can try this in your caption bar:

='YOUR TITLE ' & CHR(10)

CHR(10) (feed line) OR CHR(13) (enter or backwards), both are good. That breaks the line, so nobody can see it.

Re: How to make a chart permanently detached ?

christian77 — Tue, 03 Jun 2014 11:23:07 GMT

they'll see it if the hoover the caption bar.