I am using the following script in load editor.
Max(accounting_period) as maxaccountingperiod
Let vMaxaccountingperiod =Peek('maxaccountingperiod');
"Customer Group Descr",
if(sum(EBIDTA)<0,"Customer Group Descr",Null()) as restricted_customers
where "Fiscal Year"=('FY'&$(vMaxfiscalyear)) and accounting_period<=$(vMaxaccountingperiod)
Group by "Customer Group Descr";
I want to group restricted_customers column with recent fiscal year when there is no selection at front end. So for example when my recent fiscal year is FY18 then by default restricted_customers for FY18 are shown , but if I select FY17 from my filter restricted_customers should come respective to FY17.
Is it possible in Qlik, or please suggest some other way in achieving this,
Thanks in advance.