Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
nikhilgarg
Valued Contributor

Can anyone explain following code ??

Hey,

Can anyone explain the following code and also what is semantic load.

Semantic Load

  Previous(Sequence) as P1,

  'Successor' as Relation,

  Sequence as P2,

  'Predecessor' as Relation

resident Presidents

Thanks

17 Replies

Re: Can anyone explain following code ??

Hi,

This will give you error as Relation is repeated twice.

Regards

ASHFAQ

nikhilgarg
Valued Contributor

Re: Can anyone explain following code ??

HEy,

This is not giving any kind of error. This is example provided by Qlikview. Presidents.qvw. In that script it is written. Can u explain it what is happening ? I mean how predecessor and successor working ??

Thanks

Re: Can anyone explain following code ??

Hi,

I did not notice it was semantic load

Find the definition from help.

Semantic Load * from abc.csv;

Semantic Select Object1, Relation, Object2, InverseRelation from table1;

Regards

ASHFAQ

Highlighted
nikhilgarg
Valued Contributor

Re: Can anyone explain following code ??

HEy,

I do see in help but no such Explain of Semantic load is there.

Can you explain please.

Thanks

Re: Can anyone explain following code ??

It is nothing but use as a semantic table which having relationships that is used not for join for more read below thread

Semantic Load

Regards,

Anand

geetaalhan
Contributor

Re: Can anyone explain following code ??

Hi,

You can go through the extract given in the book (Qlikview_Reference_Manual)  at Page 385 of 942  to know about semantic load and their related examples.

Some of the extracts is as follows :

Semantic links are created by loading tables containing the relations between the objects.

  • l The table must contain exactly three or four columns.
  • l A semantic table must either contain relations between field values of different fields or between field

values of the same field. A mixture between the two is not accepted.

  • l The load or select statement loading a semantic table must be preceded by a semantic qualifier to

show that it is not a logical table.

Normally four columns are used, the first one containing the field values that have a relation to some other

field value and the third one containing the related field value.

The second column must contain the names of the relations, and finally,

the fourth one must contain the names of the inverse relations.

If three columns are used, no explicit names for the inverse relations can be given. The names given in the

second column are used both for the relation and the inverse relation. The names are then preceded or followed

by arrows.

If the relations are between field values of the same field, the first and third columns must have the same

name. Also the names of the second and fourth column, i.e. the type of the relations, must be the same.

However,if the relations are between field values of different fields, all columns must have different names.

Please find the attachment for detailed understanding.

Thanks and Regards,

Geeta

nikhilgarg
Valued Contributor

Re: Can anyone explain following code ??

Hey,

I downloaded the reference manual you attached  but it is not opening.

What to do ?

geetaalhan
Contributor

Re: Re: Can anyone explain following code ??

Hi,

Try this one.

Thanks,

Geeta

nikhilgarg
Valued Contributor

Re: Re: Can anyone explain following code ??

Hey geeta,

I was reading the page you referred for Semantic link. But htere i read that ":


"Semantic Links describe the relations between the objects rather than the objects themselves."

What does it mean ??

Thanks