topic Slowly Changing Dimensions QV in QlikView https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-QV/m-p/554591#M207196 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need your help, i explain</P><P>i want to keep the history of my table</P><P></P><TABLE><TBODY><TR><TD>ID</TD><TD>field1</TD><TD>field2</TD><TD>field3</TD><TD>field4</TD><TD>Product</TD><TD>date</TD><TD>Price</TD><TD>Step</TD><TD>scd_active</TD><TD>scd_end</TD><TD>scd_start</TD><TD>scd_version</TD></TR><TR><TD>330924</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>a</TD><TD>23/09/2013</TD><TD>150</TD><TD>a</TD><TD>0</TD><TD>23/09/2013</TD><TD>23/09/2013</TD><TD>1</TD></TR><TR><TD>478422</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>b</TD><TD>23/09/2013</TD><TD>150</TD><TD>b</TD><TD>0</TD><TD>23/09/2013</TD><TD>23/09/2013</TD><TD>2</TD></TR><TR><TD>478423</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>c</TD><TD>23/09/2013</TD><TD>150</TD><TD>c</TD><TD>0</TD><TD>23/09/2013</TD><TD>08/08/2013</TD><TD>3</TD></TR><TR><TD>478424</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>d</TD><TD>23/09/2013</TD><TD>150</TD><TD>d</TD><TD>1</TD><TD>NULL</TD><TD>08/08/2013</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P></P><P>when i use this expression sum(Price) i have 600 <SPAN lang="en"><SPAN class="hps">this result</SPAN> <SPAN class="hps">is false</SPAN></SPAN> i will have 150 in this table field "Step" change the status</P><P></P><P>any idea please</P><P></P><P>Best regards,</P><P></P><P>Emteam</P></BODY></HTML> Mon, 23 Sep 2013 12:29:19 GMT emteam162 2013-09-23T12:29:19Z Slowly Changing Dimensions QV https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-QV/m-p/554591#M207196 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need your help, i explain</P><P>i want to keep the history of my table</P><P></P><TABLE><TBODY><TR><TD>ID</TD><TD>field1</TD><TD>field2</TD><TD>field3</TD><TD>field4</TD><TD>Product</TD><TD>date</TD><TD>Price</TD><TD>Step</TD><TD>scd_active</TD><TD>scd_end</TD><TD>scd_start</TD><TD>scd_version</TD></TR><TR><TD>330924</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>a</TD><TD>23/09/2013</TD><TD>150</TD><TD>a</TD><TD>0</TD><TD>23/09/2013</TD><TD>23/09/2013</TD><TD>1</TD></TR><TR><TD>478422</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>b</TD><TD>23/09/2013</TD><TD>150</TD><TD>b</TD><TD>0</TD><TD>23/09/2013</TD><TD>23/09/2013</TD><TD>2</TD></TR><TR><TD>478423</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>c</TD><TD>23/09/2013</TD><TD>150</TD><TD>c</TD><TD>0</TD><TD>23/09/2013</TD><TD>08/08/2013</TD><TD>3</TD></TR><TR><TD>478424</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>d</TD><TD>23/09/2013</TD><TD>150</TD><TD>d</TD><TD>1</TD><TD>NULL</TD><TD>08/08/2013</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P></P><P>when i use this expression sum(Price) i have 600 <SPAN lang="en"><SPAN class="hps">this result</SPAN> <SPAN class="hps">is false</SPAN></SPAN> i will have 150 in this table field "Step" change the status</P><P></P><P>any idea please</P><P></P><P>Best regards,</P><P></P><P>Emteam</P></BODY></HTML> Mon, 23 Sep 2013 12:29:19 GMT https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-QV/m-p/554591#M207196 emteam162 2013-09-23T12:29:19Z