topic Static value in QlikView in QlikView https://community.qlik.com/t5/QlikView/Static-value-in-QlikView/m-p/356872#M132446 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>Dear is there any possiblity to create a static value from an expression?</P><P>For example, i have this table that calculates the sum of people in a region. I want that every last day of the month, the value get static on it is.</P><P>To be more clear, in Jan 31st I had 30 people, nevertheless in February 20th I have 36 people in Jan but i only want to see 30, that was the value on Jan 31st.</P><P>Is that possible?</P><P></P><P>Regards Jorge</P></BODY></HTML> Wed, 18 Jul 2012 14:14:11 GMT 2012-07-18T14:14:11Z Static value in QlikView https://community.qlik.com/t5/QlikView/Static-value-in-QlikView/m-p/356872#M132446 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>Dear is there any possiblity to create a static value from an expression?</P><P>For example, i have this table that calculates the sum of people in a region. I want that every last day of the month, the value get static on it is.</P><P>To be more clear, in Jan 31st I had 30 people, nevertheless in February 20th I have 36 people in Jan but i only want to see 30, that was the value on Jan 31st.</P><P>Is that possible?</P><P></P><P>Regards Jorge</P></BODY></HTML> Wed, 18 Jul 2012 14:14:11 GMT https://community.qlik.com/t5/QlikView/Static-value-in-QlikView/m-p/356872#M132446 2012-07-18T14:14:11Z Re: Static value in QlikView https://community.qlik.com/t5/QlikView/Static-value-in-QlikView/m-p/356873#M132447 <HTML><HEAD></HEAD><BODY><P>I think you want to look into writing data to a qvd (using STORE) and doing an incremental load of this historic data.</P><P></P><P>There are plenty of examples here in the forum, search for incremental load (and there are also samples in the manual and in the QV cookbook).</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Wed, 18 Jul 2012 14:17:56 GMT https://community.qlik.com/t5/QlikView/Static-value-in-QlikView/m-p/356873#M132447 swuehl 2012-07-18T14:17:56Z