Discussion Board for collaboration on QlikView Scripting.
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.
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.