1 Reply Latest reply: May 10, 2018 3:34 PM by Saurabh Phapale RSS

    Make my grouping dynamic in load editor

    siddharth soam

      Hi

       

      I am using the following script in load editor.

       

      Temp:
      Load
      Max(accounting_period) as maxaccountingperiod

      Resident PNL;

      Let vMaxaccountingperiod =Peek('maxaccountingperiod');

       

      Temp1:

       

      load

      "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,


      Thanks in advance.