Can anyone help me with the correct logic for this code. This seems to be showing incorrect reusult

[aarav021]

Hi I am new to Qlik Sense. Can anyone please help me with correctsolution to this as this is an urgent requirement.

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';

I want to create a dynamic variable in load editor for current fiscal year and previous fiscal year. So that I use it in table chart.

[Mark_Little]

You will need to use the peek function to populate your variables. 

Let Current_FY = PEEK('Curr_FY',0,'TableName')

Table name being the name of the Table you have created the fields in.

[aarav021]

[DATE_table1]

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 = PEEK('Curr_FY',0,'DATE_table1')

Did you mean this ?