Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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)

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)

Community Browser