Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lornafnb
Valued Contributor

Link table between 2 Fact Tables

 hi everyone

I have 2 tables that both contain Cust_no. One is a Sales table, another is a Usage table. Other fields in common are Period and Company_no

Sales                                                     Usage

Cust_no                                              Cust_no

Cust_no as Sales_Cust_no         Cust_no as Usage_Cust_No

Period                                                 Period

Company_no                                  Company_no

Count(Sales)                                  Count(Log_ons)

Link Table contains Cust_no, Period, Company_no

In my charts - for Sales - I count Distinct Sales_Cust_no

                             for Usage I count Distinct Usage_Cust_no

 

My questions...

1. Do I need to include Sales_Cust_no and Usage_Cust_no in my linking table?

2. I'd like to display how many Logons did a customer have that also had sales - would that be possible with the current design? 

3. What would my expression look like for number 2 above?

4. any other ideas for other visualizations with the data as is?

 

Much appreciated

 

Labels (1)
1 Solution

Accepted Solutions
arvind_patil
Valued Contributor III

Re: Link table between 2 Fact Tables

I think here no need of link table because rest of one KPI all fields are same

Cust_no
Cust_no as Sales_Cust_no
Period
Company_no
Sales
Log ons

Thanks & Regards,
Arvind Patil
6 Replies
arvind_patil
Valued Contributor III

Re: Link table between 2 Fact Tables

Hi,

Just Simply Concatenate both the tables and you will achieve all.

Thanks & Regards,
Arvind Patil
lornafnb
Valued Contributor

Re: Link table between 2 Fact Tables

I usually just concatenate, but I wanted to try the Link Table 😊

arvind_patil
Valued Contributor III

Re: Link table between 2 Fact Tables

I think here no need of link table because rest of one KPI all fields are same

Cust_no
Cust_no as Sales_Cust_no
Period
Company_no
Sales
Log ons

Thanks & Regards,
Arvind Patil
Highlighted
arvind_patil
Valued Contributor III

Re: Link table between 2 Fact Tables

Please refer below thread  you will get idea:

 

https://community.qlik.com/t5/Qlik-Design-Blog/Concatenate-vs-Link-Table/ba-p/1467569

 

Thanks & regards,

Arvind Patil

lornafnb
Valued Contributor

Re: Link table between 2 Fact Tables

Thank you Arvind

arvind_patil
Valued Contributor III

Re: Link table between 2 Fact Tables

Welcome