topic Slowly Changing Dimension and Master Calendar in QlikView https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimension-and-Master-Calendar/m-p/59006#M9801 <HTML><HEAD></HEAD><BODY><P>Hi, All.</P><P></P><P>I have a task to develop QV model for App.</P><P>I need to implement a model with the ability to keep a history of changing the bundle Rented place -&nbsp; Tenant.</P><P></P><P>If I choose Rented place 1.1 and time period&nbsp; 01.01.18 - 01.05.18 SalesAmount must be calculate like X+Y, not&nbsp; Y+Z&nbsp; (like w/o history Rented place -&nbsp; Tenant)</P><P><IMG __jive_id="202850" alt="Untitled presentation - Google Slides - Google Chrome 2018-05-18 22.27.10.png" class="jive-image image-1" src="/legacyfs/online/202850_Untitled presentation - Google Slides - Google Chrome 2018-05-18 22.27.10.png" style="height: 335px; width: 620px;" /></P><P></P><P>How to implement this task?</P><P></P><P>Thanks for any ideas!</P></BODY></HTML> Fri, 18 May 2018 19:48:43 GMT vadim_grab 2018-05-18T19:48:43Z Slowly Changing Dimension and Master Calendar https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimension-and-Master-Calendar/m-p/59006#M9801 <HTML><HEAD></HEAD><BODY><P>Hi, All.</P><P></P><P>I have a task to develop QV model for App.</P><P>I need to implement a model with the ability to keep a history of changing the bundle Rented place -&nbsp; Tenant.</P><P></P><P>If I choose Rented place 1.1 and time period&nbsp; 01.01.18 - 01.05.18 SalesAmount must be calculate like X+Y, not&nbsp; Y+Z&nbsp; (like w/o history Rented place -&nbsp; Tenant)</P><P><IMG __jive_id="202850" alt="Untitled presentation - Google Slides - Google Chrome 2018-05-18 22.27.10.png" class="jive-image image-1" src="/legacyfs/online/202850_Untitled presentation - Google Slides - Google Chrome 2018-05-18 22.27.10.png" style="height: 335px; width: 620px;" /></P><P></P><P>How to implement this task?</P><P></P><P>Thanks for any ideas!</P></BODY></HTML> Fri, 18 May 2018 19:48:43 GMT https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimension-and-Master-Calendar/m-p/59006#M9801 vadim_grab 2018-05-18T19:48:43Z