Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
qliktech_uk
Contributor III
Contributor III

Month in the data model

Hi,

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
zhadrakas
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.