Static value in QlikView

[#1]

Good day,

Dear is there any possiblity to create a static value from an expression?

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.

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.

Is that possible?

Regards Jorge

[swuehl]

I think you want to look into writing data to a qvd (using STORE) and doing an incremental load of this historic data.

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).

Regards,

Stefan