谁能告诉我这个 Qlik 感知表达式出了什么问题

Question

LOAD
if(Year(max(FISCAL_YEAR))=Year(Today()),
Year(max(FINANCIAL_YEAR))) as Curr_FY,
if(Year(max(FISCAL_YEAR))=Year(Today()),
Year(today()-1)) as Prev_FY
Resident [data_table];
Let Current_FY = '=Curr_FY';
Let Last_FY = '=Prev_FY';

我想为当前的FISCAL_YEAR和最近的FISCAL_YEAR创建动态变量

Answer 1

如果表中只包含Curr_FY和Prev_FY的单个值，则可以使用peek脚本函数在变量

中获取值

Let Current_FY = peek('Curr_FY');
Let Last_FY = peek('Prev_FY');

记住，如果有多个值，那么peek将返回最后加载的值