Discussion Board for collaboration related to QlikView App Development.
I have a date field SUMMARY_DATE (31/05/2018) and for simplicity in coding, I would like to create another field where I can mark the latest date as zero and the prior as:
Ideally within my Script.
Thanks for all the help,
This might be another way...
LOAD * INLINE [
RangeSum(Peek('RELATIVE_MONTH'), (Year(SUMMARY_DATE)*12 + Month(SUMMARY_DATE))-(Year(Previous(SUMMARY_DATE))*12 + Month(Previous(SUMMARY_DATE)))) as RELATIVE_MONTH
DROP Table Table;
View solution in original post
why not :
loading your date in a table
loading a 2nd table from the previous resident on order by date descending
computing a field with -1*rowno()+1
Thank you very much.