- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what is semantic Load?
Hi tell me about semantic load and how use in qlikview with simple example.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.