Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Values don't change after a date.

Hi,

You know how in excel you can copy a cell with a value calculated by a formula and then paste it as a value, can we do that in QS?

So current date it looks at the figures calculated with the expressions or in the script.  But our historic data needs to be locked down, what the calculated value was at the end of yesterday.  It can't change today.

Both have to be in the same table or concatenated or joined or however it can be done.  Can it be done?

Regards

 

 

 

 

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

Yes it can be done, but it would have to be something that is calculated in script and stored out to a data file, for prior values.  

Then you can have an if before this data take the data File value else do the set analysis.

Would need more details to help with more detail. 

D19PAL
Creator II
Creator II
Author

Thanks.

 

What details do you need?