topic what is semantic Load? in QlikView

what is semantic Load?

Wed, 25 Nov 2020 16:16:04 GMT

Hi tell me about semantic load and how use in qlikview with simple example.

Thanks

Re: what is semantic Load?

Anonymous — Mon, 03 Oct 2016 19:37:38 GMT

Its a load used to establish relations between the objects

you can use the below links:

https://qliktech-public-v7.hosted.jivesoftware.com/thread/172991

Can anyone explain following code ??

Re: what is semantic Load?

jagan — Tue, 04 Oct 2016 06:02:45 GMT

Hi,

Check this link

Re: Semantic Load with Example

Download the file and check the script.

If you do not have license run below script and create filters for all the columns.

Presidents:

LOAD * INLINE [

Sequence, Name, Party

1, George Washington, Federalist

2, John Adams, Federalist

3, Thomas Jefferson, Dem.-Rep

4, James Madison, Dem.-Rep

5, James Monroe, Dem.-Rep

6, John Quincy Adams, Dem.-Rep

7, Andrew Jackson, Democrat

8, Martin Van Buren, Democrat

9, William Henry Harrison, Whig

10, John Tyler, Democrat

11, James Knox Polk, Democrat

12, Zachary Taylor, Whig

13, Millard Fillmore, Whig

14, Franklin Pierce, Democrat

15, James Buchanan, Democrat

16, Abraham Lincoln, Republican

17, Andrew Johnson, Republican

18, Ulysses Simpson Grant, Republican

19, Rutherford Birchard Hayes, Republican

20, James Abram Garfield, Republican

21, Chester Alan Arthur, Republican

22, Grover Cleveland, Democrat

23, Benjamin Harrison, Republican

24, Grover Cleveland, Democrat

25, William McKinley, Republican

26, Theodore Roosevelt, Republican

27, William Howard Taft, Republican

28, Woodrow Wilson, Democrat

29, Warren Gamaliel Harding, Republican

30, Calvin Coolidge, Republican

31, Herbert Clark Hoover, Republican

32, Franklin Delano Roosevelt, Democrat

33, Harry S Truman, Democrat

34, Dwight David Eisenhower, Republican

35, John Fitzgerald Kennedy, Democrat

36, Lyndon Baines Johnson, Democrat

37, Richard Milhous Nixon, Republican

38, Gerald Rudolph Ford, Republican

39, James Earl Jr Carter, Democrat

40, Ronald Wilson Reagan, Republican

41, George Herbert Walker Bush, Republican

42, William Jefferson Clinton, Democrat

43, George Walker Bush, Republican

44, Barack Hussein Obama II, Democrat

];

SemanticTable:

Semantic Load

Previous(Sequence) as Sequence,

'Successor' as Relation,

Sequence as Sequence,

'Predecessor' as Relation

resident Presidents;

Regards,

Jagan.

Re: what is semantic Load?

nsetty — Thu, 26 Jul 2018 03:43:01 GMT

I tried in Qlik Sense June 2018 version;

SemanticTable gets created, SemanticTable table is available sheets for any chart addition; however in "Data Manager". SemanticTable does not appear.

Re: what is semantic Load?

pintucs20 — Sat, 28 Jul 2018 05:12:06 GMT

Hi ,

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 Concatenation.