Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

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
Master III
Master III

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
Author

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

arulsettu
Master III
Master III

go to data load editor and use above query

Not applicable
Author

[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
Author

[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
Master III
Master III

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