topic Re: Linked function in QlikView

Linked function

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

what is the used of linked function in qlikview?.

Thank you..

Re: Linked function

prma7799 — Mon, 05 Jun 2017 04:05:07 GMT

Link Table

http://www.qlikfix.com/2016/09/08/elegant-link-table-script/

how to create link table in Qlikview?

Re: Linked function

kamal_sanguri — Mon, 05 Jun 2017 05:41:58 GMT

There is no such function "Linked" (AFAIK). However keyword Linked can be associated with Link tables which is a method to avoid synthetic keys.

For Ex: You have two tables with more than one common fields. Qlikview will create a synthetic key which would be associated with both the tables. In order to avoid those syn keys you can create a composite key in your tables and get rid of those common columns. Now your tables would be connected with the composite key you created and there would not be any syn keys in your data model.

I have two tables TableA and TableB.

TableA	TableB
Field1	Field1
Field2	Field2
Field3	Field4

Now, when you load these two tables you will get a syn key as they have two common coloumn.

Now, I concatenated Field1 & Field2 to create a key in both tables. My new data model looks like

Apart from this, Linked can also be associated with Linked objects. Once you copy a Qlikview chart or other object to paste it somewhere else in your application. When you do a right click to paste it, you get an additional option to paste object as Link object.

If you select this option the new object would be linked to original object. Now, if you make any change to one object it would be replicated same way in other.

And, if you right click on any object and you see Linked object, that means there are some other objects linked to it and if you change that object other object will also get changed.

Re: Linked function

Anonymous — Mon, 05 Jun 2017 08:30:15 GMT

Hi,

Linked Function.............

in qlikview we don't have separate linked functions.

in tables,

if we have any common fields in multiples tables these common fields to be called as linked fields.

based on these linked fields we can perform the data modelling in qlikview.

and coming to the objects,

we have the linked objects..in qlikview.

If you want's to take the same copy of object in application,you can copy that and you can paste with paste sheet object and paste sheet object as a link.

we have these two options like this to paste the objects.

if you use paste sheet object it will treated likes normal object

and

if you paste with paste sheet object as a link it will treat that object as linked object.

here we have to discuss about diff b/w normal object and linked object.

linked object...........it will depends on the existing object(means...original object).

if we made any changes on existing object linked object is reflects with that changes irrespective of position.

but normally copied object (by using paste sheet object) will not depends on that existing object.

Re: Linked function

Anonymous — Wed, 07 Jun 2017 09:51:27 GMT

in script when we used this keyword?

Re: Linked function

Anonymous — Wed, 07 Jun 2017 10:16:13 GMT

Maybe that is your field name. In Qlikview we dont have " Linked " word.

Re: Linked function

Anonymous — Wed, 07 Jun 2017 10:17:06 GMT

Which version Qlikview are you using?

Re: Linked function

Anonymous — Wed, 07 Jun 2017 10:25:51 GMT

no , i don't have any field with Linked name .i am using Qlikview 11

and one thing it contain a blue color .

Re: Linked function

Anonymous — Wed, 07 Jun 2017 10:49:48 GMT

In Qlikview 12 version it is not available. Let me check 11 version.

Re: Linked function

Anonymous — Wed, 07 Jun 2017 11:15:34 GMT

ok..

Re: Linked function

avinashelite — Wed, 07 Jun 2017 11:54:22 GMT

Its available in QV 11 but I have never used it . may be a un-used keyword which might be removed the latest version

Re: Linked function

kamal_sanguri — Fri, 09 Jun 2017 05:13:35 GMT

That's real strange, even if it is the field name it should not have autocomplete functionality. I will research more about it.