topic Semantic Load with Example in QlikView

Semantic Load with Example

nihhalmca — Fri, 17 Jul 2015 06:16:54 GMT

Hi All,

Can any body share knowledge on "Semantic" load with example.

Thank you,

Regards,

NiHhal.

Re: Semantic Load with Example

jonathandienst — Fri, 17 Jul 2015 06:20:57 GMT

The Presidents.qvw document installed with the examples when you installed Qlikview is a good example of a semantic load. The example documents are on C:\Program Files\QlikView\Examples\Documents by default.

Re: Semantic Load with Example

Kushal_Chawda — Fri, 17 Jul 2015 06:25:29 GMT

Please see the below link

Semantic load

Re: Semantic Load with Example

stevedark — Fri, 17 Jul 2015 06:56:45 GMT

This thread has some discussion on the topic:

Can anyone explain following code ??

Hope that helps.

Steve

Re: Semantic Load with Example

jagan — Sat, 18 Jul 2015 00:46:51 GMT

Hi Nihhal,

PFA file hope it helps you. In the Attached Qlikview file by clicking the Successor and Predecessor buttons the corresponding president will be selected automatically.

Regards,

Jagan.

Re: Semantic Load with Example

qlikviewwizard — Sat, 18 Jul 2015 04:48:19 GMT

Thank you jagan

I learned new thing.

Re: Semantic Load with Example

nihhalmca — Mon, 20 Jul 2015 10:26:15 GMT

Thanks Jagan Mohan.

Re: Semantic Load with Example

pgrenier — Tue, 12 Jun 2018 14:17:13 GMT

Thanks! Excellent and very insightful example!

Re: Semantic Load with Example

marc8891 — Thu, 12 Dec 2019 17:36:48 GMT

For those of you who don't want to download it here is the script from the solution posted:

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;

Re: Semantic Load with Example

Levente_Szittya — Mon, 15 Nov 2021 12:34:59 GMT

Hi Jagan,

Semantic load is something new for me that I have never come across before in QlikSense.

I was glad that I can learn something about it using your app, when I realised that it is a QV app. Unfortunately it does not transformed properly to QS (using QV converter in Dev Hub)... There remains no front-end content (no master items) in the transformed file, only the script.

Could you be so kind to make a QS version of it?

Thanks and best regards,

Levente

Re: Semantic Load with Example

Levente_Szittya — Mon, 15 Nov 2021 13:11:50 GMT

Hi,

I have tried to get something out of the loaded content and voila'... Here you go with the QS version.

I have simply used the field [Relation] in a filter pane. This field is created at the "background" by semantic load (not shown in the data model viewer, but you can refer to it in the front-end).semantic load does not show up in DMWsemantic load shows up in the front-end

There is room to improve look and feel in the front-end, but now it shows what it is for...

Jagan, thanks for the hints and the script...

Best regards,

Levente