report data from multiple tables in one application

[xingstar97]

I wanted to report data from two tables in one application, one table is weekly revenue, the other table is today's revenue. Both tables include same dimension variables (e.g., product category, location, status), and I have a table for each dimension (e.g., product category table, location table, status table). I'm wondering how I should build data model.

I was able to build a data model with today's revenue as the primary table and each dimension table connecting to the primary table with one key. But when I include the weekly revenue table, the weekly revenue table connected to the today's revenue today table with synthetic key (the share the same dimension variables). I wanted to remove the synthetic key and make the weekly revenue table connecting to the dimension tables.

I'm wondering if this can be achieved in Qlik sense. Does Qlik identify keys only by names? Could I manually break a specific link between tables even they have variables with the same name? 

[MayilVahanan]

Hi

You can try like below

Concatenate the today's revenue table with weekly revenue table as they have same info with flag field to separate each other. 

Load *, 'Today' as flag from todayrevenue.qvd(qvd);

Concatenate

Load *, 'Weekly' as flag from weeklyrevenue.qvd(qvd);

in front end, you can use flag wherever required. 

[xingstar97]

Thanks for your response!

I have two KPI charts, one always showing today's sum revenue, the other showing a specific week's sum revenue (the specific week is determined by a filter pane to select a specific date). I also have other filters (e.g., product category, location, status) which can filter both today and a specific week's revenue.

If I concat two tables, when I select a specific date for the week's sum revenue KPI, it changes today's sum revenue as well.

I thought about using alternative states, but today and week revenue are filtered by some common filters (e.g., product category, location, status), so I can't completely separate them.

[MayilVahanan]

Hi

You can ignore the field selection by using set analysis.

Ex: sum({<Field1=>}Revenue)