遇到一个问题，我想用前15分钟的值来替换整点的值，如图；脚本应该怎么处理
0
如下图：
没有找到相关结果
重要提示：提问者不能发表回复，可以通过评论与回答者沟通，沟通后可以通过编辑功能完善问题描述，以便后续其他人能够更容易理解问题.
1 个回复
曹浩 - QlikView顾问、QV讲师 2015-03-24 回答
赞同来自:
Test:
LOAD begintime,
KPI1 as KPI1_TEMP,
KPI2 as KPI2_TEMP,
KPI3 as KPI3_TEMP
FROM
test.xlsx
(ooxml, embedded labels, table is Sheet1);
Final:
LOAD
begintime,
if(Minute(begintime - Previous(begintime))=15,Previous(KPI1_TEMP),KPI1_TEMP) as KPI1,
if(Minute(begintime - Previous(begintime))=15,Previous(KPI2_TEMP),KPI2_TEMP) as KPI2,
if(Minute(begintime - Previous(begintime))=15,Previous(KPI3_TEMP),KPI3_TEMP) as KPI3
Resident T
Order by begintime;
DROP Table Test;
目的达成：