how can i make a resident of a qvd

[siddharthsoam]

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

[migueldelval · Accepted solution]

Hi,

Follow this steps for example.

One --> name:

                Load Table1 from excel

Two --> Concatenate

               Load Table2 from excel

Three --> Store name into .../name.Qvd.

               Drop Table name;

-------------> You don´t need to make this if you don´t change of app.

Four --> name:

               Load * FROM .../.nameQVD (QVD);

               name2: Load * Resident name;

--------------> Take care with sythetics

Regards

Miguel del Valle

[siddharthsoam]

also if i store 2 tables in a qvd , i want all the columns of table1 to load . How can i achieve this via load statement

much thanks:)