Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikconsultant
Contributor II

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
MVP
MVP

Re: Where to insert the Master Calendar?

Re: Where to insert the Master Calendar?

Perhaps this discussion helps: Master calendar


talk is cheap, supply exceeds demand
agomes1971
Valued Contributor

Re: Where to insert the Master Calendar?

qlikconsultant
Contributor II

Re: Where to insert the Master Calendar?

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

agomes1971
Valued Contributor

Re: Where to insert the Master Calendar?

Hi,

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

Regards

André Gomes

Community Browser