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

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

aarav021 — Wed, 07 Dec 2022 07:11:54 GMT

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.

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

Mark_Little — Wed, 07 Dec 2022 07:44:09 GMT

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.

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

aarav021 — Wed, 07 Dec 2022 08:14:31 GMT

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