Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
Not applicable

Hierarchy pls

Hi

Can you please let me know what is the steps to create reports and dashboards.

and

How can i join 2 tables (Left out)

I have 2 tables A and B. .

Thanks

Govind

1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: Hierarchy pls

join will make two tables into single table. change the field names in second table into first table name(similar names)

View solution in original post

6 Replies
arulsettu
Honored Contributor III

Re: Hierarchy pls

1.creating dashboards is purely based on requirement only.

2. Table1:

load a

       b

       c

from table1;

left join(Table1)

Table2:

load a

       b

       b

from table2;

Not applicable

Re: Hierarchy pls

How and where can i give this condition.I am new to sense can you please give me steps

arulsettu
Honored Contributor III

Re: Hierarchy pls

go to data load editor and use above query

Not applicable

Re: Hierarchy pls

[GL_Fact]:
LOAD
[Expense_GL] AS [Expense_GL],
[Posted Date] AS [Posted Date-Year];
LOAD [Expense_GL],
[Posted Date]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is GL_Fact);

Left join [GL_Fact]

[Expenses_Fact]:
LOAD
[Expense_Ex] AS [Expense_Ex],
[Year] AS [Posted Date-Year];
LOAD [Expense_Ex],
[Year]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is Expenses_Fact);

I am getting error..

Not applicable

Re: Hierarchy pls

[GL_Fact]:
LOAD
[Expense_GL] AS [Expense_GL],
[Posted Date] AS [Posted Date-Year];
LOAD [Expense_GL],
[Posted Date]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is GL_Fact);

Left join

[Expenses_Fact]:
LOAD
[Expense_Ex] AS [Expense_Ex],
[Year] AS [Posted Date-Year];
LOAD [Expense_Ex],
[Year]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is Expenses_Fact);

Now looks ok but in my data model viewer I can see single table instead of 2 tables.but I can see both tables fields.

arulsettu
Honored Contributor III

Re: Hierarchy pls

join will make two tables into single table. change the field names in second table into first table name(similar names)

View solution in original post