Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
[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 ?