topic Re: Please tell about code in SemanticPresidents Table. in QlikView

Please tell about code in SemanticPresidents Table.

nikhilgarg — Tue, 21 Oct 2014 08:24:38 GMT

Hey,

I have a problem. In attached image what is P1 and P2 ??

And also i cannot undeerstand the code of "SemanticPresidents Table".

Please tell. This code is of Presidents.qvw given in Qlikview/Documents folder.

Thanks

Re: Please tell about code in SemanticPresidents Table.

kuba_michalik — Tue, 21 Oct 2014 08:59:30 GMT

I assume you have read about Semantic Load in the Reference Manual. P1 and P2 are temporary aliases for Sequence that could be useful if it was a select from a database. You actually don't need them here, this code:

Previous(Sequence) as Sequence,

'Successor' as Relation,

Sequence,

'Predecessor' as Relation

works just as well.

Semantic tables are special, so the duplicate column names are expected.

Re: Please tell about code in SemanticPresidents Table.

nikhilgarg — Tue, 21 Oct 2014 09:03:30 GMT

Hey,

Thanks for explaining but i even dont know about semantic load. Can you please tell me ?? May be then only i could be able to understand code.

Thanks

Re: Please tell about code in SemanticPresidents Table.

senpradip007 — Tue, 21 Oct 2014 09:39:01 GMT

Go through this link http://community.qlik.com/message/441508#441508

Re: Please tell about code in SemanticPresidents Table.

nikhilgarg — Tue, 21 Oct 2014 11:22:25 GMT

Hey,

I go through it but still didnot get anything.

Please see if you can help more.

Thanx