Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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