topic Re: Relationship between cloned/copied objects/listboxes in QlikView

Relationship between cloned/copied objects/listboxes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone! I hope your 2017s have started well!

I currently am still understanding Qlikview and all of it's capabilities (which are incredible!). However, as I am using the program and drawing analysis from it, I am interested in the connections between the listboxes and charts (basically all the objects on the sheets). I tend to clone many of my charts (as they have a lot of complicated expressions) or copy and paste them; could this potentially cause a problem? Are these objects now linked? What does this link cause/do? I also know that, even when I create the objects individually, they still only look at the data I've selected (also as if having a link between the objects don't really do anything.); is this true?

Also - what are disconnected objects? (it popped up as a potential tag, and I've heard of it .. I know of detached objects .. and those don't change when you select data .. but not disconnected.)

Overall, any help or advice would be highly appreciated!! Many thanks for your time and efforts!

Re: Relationship between cloned/copied objects/listboxes

vinieme12 — Fri, 06 Jan 2017 11:21:18 GMT

Cloned/Copy is the same thing: If you simply copy paste an object, both objects are independent of each other

if you copy an object and Paste as link : Then both object share same properties, any changes to one object is automatically applied to the other linked object.

Try this:

Create a text box

1) copy paste

2) copy and Right click >> PAste object as link.

now make changes to the Object pasted as link and see how it affect the original object.

Re: Relationship between cloned/copied objects/listboxes

Anonymous — Fri, 06 Jan 2017 11:24:35 GMT

Hi Vineeth! Thank you so much for your answer! However, I am still confused on what you mean by properties .. is that the sort functions of the chart? Or if I change one expression in one, it will automatically change in the other?

Re: Relationship between cloned/copied objects/listboxes

annafuksa1 — Fri, 06 Jan 2017 11:26:00 GMT

For situation where you copy and paste please look at the picture if you will choose option 1 (Orange) they will not be link if you will change one object other will not affect. if you will choose option 2 (Green) they will be link Please remember that any change in one object will affect other object.

if you do not want to connect object with rest of a dashboard you have few options, set analysis formula will look for example sum({1}Sales), you can detach object or use alternate state. that way any selection will not affect your chart

Anna

Re: Relationship between cloned/copied objects/listboxes

vinieme12 — Fri, 06 Jan 2017 11:34:55 GMT

Any kind of change , in any properties or expressions , caption, layout everything there is

Try it out

Create a text box = 'Hello'

Copy and Paste (After this step you have 2 text boxes)

Now Copy the Original Textbox >> Right Click anywhere of the Sheet and Select >> Paste Object as Link

Now Change the background color of the Linked Text box and change Text to 'HI!' and see how it affects the original text box

Re: Relationship between cloned/copied objects/listboxes

Anonymous — Fri, 06 Jan 2017 12:02:07 GMT

Hi Anna,

Thank you so much for taking the time to answer my question! It is much appreciated.

I understand the basic idea of set analysis; so say I have a field of color (red, blue, green, yellow, etc), and I want to only look at the information with the colors blue and green; by using the set analysis formula in the expression, I can create a chart/object that literally only looks at that and does not cause a selection?

Re: Relationship between cloned/copied objects/listboxes

annafuksa1 — Fri, 06 Jan 2017 12:44:27 GMT

yes,

the formula will be for example sum({$<Color= {'blue' , 'green'}>}Color) that way you will show only this 2 colors and ignore only selection for Color (if you will choose for example red , there will be no impact but if you will choose for example year 2016 there will be impact and show you data for 2016

sum({1<Color= {'blue' , 'green'}>}Color) that way you will show only this 2 colors and ignore any other selection (if you will choose for example red , there will be no impact , if you will choose for example year 2016 there will be no impact.

Anna