Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aarav021
Contributor III
Contributor III

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

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.

2 Replies
Mark_Little
Luminary
Luminary

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
Contributor III
Contributor III
Author

[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 ?