topic Re: slowly changing dimension in QlikView https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429900#M160257 <HTML><HEAD></HEAD><BODY><P>The difference between that tables is the modified date right?</P><P>So.. I need an example of the script <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Dec 2012 13:47:46 GMT farolito20 2012-12-13T13:47:46Z slowly changing dimension https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429897#M160254 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: Arial, sans-serif; font-size: 14px; background-color: #f5f5f5;">is it really necessary have a history table to trace back everything?</SPAN></P></BODY></HTML> Wed, 12 Dec 2012 14:22:36 GMT https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429897#M160254 farolito20 2012-12-12T14:22:36Z Re: slowly changing dimension https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429898#M160255 <HTML><HEAD></HEAD><BODY><P>Sometimes yes, sometimes no. Is it necessary to know that a salesperson belonged to salesteam X in 2010 and now belongs to salesteam Y? It always depends on the audience and business needs I guess</P></BODY></HTML> Thu, 13 Dec 2012 09:15:28 GMT https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429898#M160255 Anonymous 2012-12-13T09:15:28Z Re: slowly changing dimension https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429899#M160256 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">How I can save the modified data in a table .qvd?</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">For example, I have an employees_info table and I modified a phone number, but I wanna keep the other number because probably it's ussefull to make an report using old data.</SPAN></P><P></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">id_employee , name, phone</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">001, carlos, 4556122</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;"><BR /></SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">id_employee , name, phone</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="background-color: #f5f5f5; font-size: 14px; font-family: Arial, sans-serif;">001, carlos, 9856741</SPAN></P></BODY></HTML> Thu, 13 Dec 2012 13:45:48 GMT https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429899#M160256 farolito20 2012-12-13T13:45:48Z Re: slowly changing dimension https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429900#M160257 <HTML><HEAD></HEAD><BODY><P>The difference between that tables is the modified date right?</P><P>So.. I need an example of the script <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Dec 2012 13:47:46 GMT https://community.qlik.com/t5/QlikView/slowly-changing-dimension/m-p/429900#M160257 farolito20 2012-12-13T13:47:46Z