Re: Please tell about code in SemanticPresidents T... - Qlik Community

nikhilgarg · ‎2014-10-21

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

kuba_michalik · ‎2014-10-21

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.

nikhilgarg · ‎2014-10-21

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

senpradip007 · ‎2014-10-21

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

nikhilgarg · ‎2014-10-21

Hey,

I go through it but still didnot get anything.

Please see if you can help more.

Thanx

Please tell about code in SemanticPresidents Table.