Temp: Load Max(accounting_period) as maxaccountingperiod
Let vMaxaccountingperiod =Peek('maxaccountingperiod');
"Customer Group Descr", if(sum(EBIDTA)<0,"Customer Group Descr",Null()) as restricted_customers
Resident PNL 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,