Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

Month in the data model


I have defined a key to join the tables in my data model which conmprises of phone number and month. As the requirement earlier was to look at only the lastmonth.

Now I need to look at the last 6 months data and show a trend.

Should I keep the key as it is and then add a date field in each table that need to join to a calendar table?

Is there any better solution?

Thanks in advance.

Tags (1)
1 Reply
Valued Contributor II

Re: Month in the data model

i would definitely add the date field and add a master calender.

Master Calendar Generation Script

i think you have to Keep the key as it is.