Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator III
Creator III

Where to insert the Master Calendar?

Hi,

I have the following problem. I have three tables with 3 dates (see image 1).

Data_model_1.PNG

I want to create a report with shows in one table the following points:

  • How many new customers I get per month?
  • How customers ordered per month?
  • How many customers paid per month?

For that my plan is to change the data model to this:Data_model_2.PNG

But this designs is not perfect. The user has still to select 2 Shops_ID to change the table. Any suggestion for a better solution?

5 Replies
MK_QSL
MVP
MVP

Gysbert_Wassenaar

Perhaps this discussion helps: Master calendar


talk is cheap, supply exceeds demand
agomes1971
Specialist II
Specialist II

qlikconsultant
Creator III
Creator III
Author

Thanks  for the tips. I think I found a solution. Testing at the moment.

agomes1971
Specialist II
Specialist II

Hi,

then post you're solution here that would be nice!

Regards

André Gomes