Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prakash_1981
New Contributor

Report to fetch from 2 tables

I got stuck in below issue:

I am having a Category field and associated data in table.In this category i have multiple type of categories.

I am having another table Category where Categories are grouped in to 3 major group.

Now i need a data view which shows all details(count) based on the category groups.

I am struggling to link two tables and get this report done.

Can anyone help.

Regards

S, Prakash

1 Reply
Luminary
Luminary

Re: Report to fetch from 2 tables

Hi,

to associate the two tables the "Category" field must be labeled exactly the same in both of them:

FactTable:

LOAD

ID,

Date,

Category,

Value

FROM Source;

CategoryGroups:

LOAD

Category,

CategoryGroup

FROM Source2;

Then you can use CategoryGroup as a dimension and Sum(Value) as an expression.

Community Browser