Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
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.

1 Reply
Specialist II
Specialist II

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.