Qlikview Training Datavisualization Data

Qlikview Training Datavisualization Data

Data Visualizations

Data

Joins

Region:
LOAD * INLINE [
RegionID, RegionName
1,East
2,West
3,North
4,South
];

INNER JOIN (Region)
RegionContact:
LOAD * INLINE [
RegionID, CustomerName
1,Johny
2,Ramesh
5,Gopi
];

///$tab Main
SET ThousandSep=’,’;
SET DecimalSep=’.’;
SET MoneyThousandSep=’,’;
SET MoneyDecimalSep=’.’;
SET MoneyFormat=’Rs. #,##0.00;Rs. -#,##0.00′;
SET TimeFormat=’hh:mm:ss’;
SET DateFormat=’DD-MM-YYYY’;
SET TimestampFormat=’DD-MM-YYYY hh:mm:ss[.fff]’;
SET MonthNames=’Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec’;
SET DayNames=’Mon;Tue;Wed;Thu;Fri;Sat;Sun’;

///$tab Variables
LET vDefine = 1;
LET vLeftActivator = 1;
LET vRightActivator = 0;
LET vInnerActivator = 0;
LET vOuterActivator = 0;
///$tab Left Join Table
if $(vDefine) = $(vLeftActivator) then

Table1:
LOAD * Inline
[
Key, ColA
1,R1
2,R2
3,R3
];

Left Join

Table2:
LOAD * Inline
[
Key, ColC
1,F1
2,F2
4,F4
];

END If
///$tab Right Join
if $(vDefine) = $(vRightActivator) then

Table1:
LOAD * Inline
[
Key, ColA
1,R1
2,R2
3,R3
];

Right Join

Table2:
LOAD * Inline
[
Key, ColC
1,F1
2,F2
4,F4
];

END If
///$tab Inner Join
if $(vDefine) = $(vInnerActivator) then

Table1:
LOAD * Inline
[
Key, ColA
1,R1
2,R2
3,R3
];

Inner Join

Table2:
LOAD * Inline
[
Key, ColC
1,F1
2,F2
4,F4
];

END If
///$tab Outer Join
if $(vDefine) = $(vOuterActivator) then

Table1:
LOAD * Inline
[
Key, ColA
1,R1
2,R2
3,R3
];

Outer Join

Table2:
LOAD * Inline
[
Key, ColC
1,F1
2,F2
4,F4
];

END If

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.