11 Replies Latest reply: Jun 18, 2018 7:51 AM by siddharth soam RSS

    how can i make a resident of a qvd

    siddharth soam

      i have qvd named cease.qvd. In that there is a PnL table.

       

      I am loading the PnL table from the qvd-

      load * from [lib://pnl/cease.qvd] (qvd);

       

      Then i want to make a resident table from PnL-

       

      tab2:

      Load

      "Fiscal Year",

      Quarters,

      "Customer Group Descr",

      SBU_leaders,

      If(((sum(EBIDTA)/sum(new_revenue))*100)<0,'<0%',

      If(((sum(EBIDTA)/sum(new_revenue))*100)>=0 and (sum(EBIDTA)/sum(new_revenue))*100<10,'0-10%',

      If(((sum(EBIDTA)/sum(new_revenue))*100)>=10 and (sum(EBIDTA)/sum(new_revenue))*100<20,'10-20%',

      If(((sum(EBIDTA)/sum(new_revenue))*100)>=20,'>=20%','<0%')))) as EBIDTA%_categorization

      Resident PNL  //??

      Group by "Fiscal Year",Quarters,"Customer Group Descr",SBU_leaders;

       

       

      If i try making a resident of PnL it is showing me a an error. , how can i make a resident by loading the qvd with the above script.

       

      New to making qvd's, request your help