topic Re: Can anyone explain following code ?? in QlikView

Can anyone explain following code ??

nikhilgarg — Mon, 27 Oct 2014 05:08:10 GMT

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

Re: Can anyone explain following code ??

ashfaq_haseeb — Mon, 27 Oct 2014 05:13:59 GMT

Hi,

This will give you error as Relation is repeated twice.

Regards

ASHFAQ

Re: Can anyone explain following code ??

nikhilgarg — Mon, 27 Oct 2014 05:47:04 GMT

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 ??

ashfaq_haseeb — Mon, 27 Oct 2014 05:55:54 GMT

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

Re: Can anyone explain following code ??

nikhilgarg — Mon, 27 Oct 2014 06:06:15 GMT

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 ??

its_anandrjs — Mon, 27 Oct 2014 06:07:10 GMT

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

Re: Can anyone explain following code ??

Anonymous — Mon, 27 Oct 2014 11:07:19 GMT

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

Re: Can anyone explain following code ??

nikhilgarg — Mon, 27 Oct 2014 11:16:40 GMT

Hey,

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

What to do ?

Re: Re: Can anyone explain following code ??

Anonymous — Mon, 27 Oct 2014 11:35:43 GMT

Hi,

Try this one.

Thanks,

Geeta

Re: Re: Can anyone explain following code ??

nikhilgarg — Tue, 28 Oct 2014 05:39:32 GMT

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

Re: Re: Can anyone explain following code ??

Anonymous — Tue, 28 Oct 2014 05:50:35 GMT

Hey Nikhil,

Please refer Page No. 367 of 942 of the same book.

Hope information on that page will clear your doubt.

Thanks,

Geeta

Re: Re: Can anyone explain following code ??

nikhilgarg — Tue, 28 Oct 2014 06:06:25 GMT

Hey,

But can you please explain what is Objects here??

Thanks

Re: Re: Can anyone explain following code ??

Anonymous — Tue, 28 Oct 2014 06:23:30 GMT

Hey Nikhil,

The extract of PageNo. 260 of 942 which is as follows :-

--------------------------------------------------------------------------------------------------------------------------------

"Tables containing relations between objects can be loaded through a semantic prefix.

The syntax is:

semantic( loadstatement | selectstatement)

Examples:

Semantic Load * from abc.csv;

Semantic Select Object1, Relation, Object2, InverseRelation from

table1;

Tables loaded through a semantic statement cannot be concatenated."

---------------------------------------------------------------------------------------------------------------------------------

Above snipet clearly signifies that "Object" in semantic refers to field(Column) in a table .

Thanks,

Geeta

Re: Re: Can anyone explain following code ??

nikhilgarg — Tue, 28 Oct 2014 06:45:10 GMT

Hey,

Thanks Geeta . My doubt is resolved.

Can You please explain this also:

Previous(Sequence) as Sequence, // What is the value of (Sequence) here ?? And value of (Previous Of sequence) ??

'Succesor' as Relation,

Sequence,

'Predecessor' as Relation

resident President_Data;

According to me default value of Sequence should be latest value of U.S President. But when i click Predecessor it shows me Barack Obama and when i click Successor it shows me George Washington. Hows that possible??

Please resolve the doubt.

Thanks

Re: Re: Can anyone explain following code ??

Anonymous — Tue, 28 Oct 2014 07:19:51 GMT

Hey Nikhil,

Here use of 'Previous()' comes into picture.

Previous() will save the above value of the current row of 'sequence field' that is why when you click predecessor ,it shows you the row that belongs to (current sequence -1) .

Means,keep in mind the sequence field value when you click on Predecessor or successor value of ListBox (Relation) available in the Presidents tab of the application.

Hope it will help you.

Thanks,

Geeta

Re: Re: Can anyone explain following code ??

nikhilgarg — Tue, 28 Oct 2014 07:36:08 GMT

Hey thanks but ,

If default value of Sequence is of current president , Right ??

Then, if i click Successor which is Previous(Sequence) then , it should show previous of Barack obama , i.e GWBush(at No.43). But it is not happening right.

Please help.

Re: Re: Can anyone explain following code ??

Anonymous — Tue, 28 Oct 2014 09:53:22 GMT

Hi Nikhil,

If you see carefully the rules of Semantic (Page No. 385 of 942) ,it tells that

--------------------------------------------------------------------------------------------------

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.

--------------------------------------------------------------------------------------------------

Normally selections are made explicitly by clicking on the field values(here field value means values of the same column) that are interesting.

There is, however,

also a way to make selections indirectly through semantic links. These are similar to field values(here field values of field comes from two different columns having same name as 'Relation'),

but with the difference that they describe the relations between the objects rather than the objects themselves.

They appear as a list of buttons.

When clicking on a semantic link, a selection is made in an other field.

now ,you can understand the meaning of a line

'they describe the relations between the objects rather than the objects themselves'

Semantic Load

Previous(Sequence) as P1,

'Successor' as Relation,

Sequence as P2,

'Predecessor' as Relation

resident Presidents

So,we only have to follow the rules of semantic ,Qlikview will automatically parse that code and consider previous(sequence) as predecessor and not successor.

Hope this will help.

Thanks,

Geeta

Re: Re: Can anyone explain following code ??

nikhilgarg — Tue, 28 Oct 2014 10:17:18 GMT

HEy,

Ohhk Thanx.